Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server

 Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server

udayarumilli_cpu_memory_io_usage

CPU Usage, I/O Usage and Memory Usage of database

 

Database level / Database wise CPU, memory and I/O usage
As part of DBA’s daily checklist, we need to monitor few parameters of a database throughout the day. It includes CPU utilization, Memory utilization and I/O utilization. Here are the T-SQL scripts to monitor sql server instances database wise.

CPU Utilization:


CPU Utilization History:

The query retrieves the SQL Server instance CPU usage from last 10 minutes.

SQLServer_Process_CPU_Utilization: Percentage of CPU utilizing by SQL Server instance
Sytem_Idle_Process:  Percentage of CPU is idle
Other_Process_CPU_Utilization: Percentage of CPU utilizing by all other processes other than SQL Server instance.  
Event_Time: Time when these details has been captured

I/O Usage by database:

Memory usage by Database:

Posted in Performance Tuning, SQL Server DBA | Tagged , , , , , , , , , , , , , | 1 Comment

Leave a Reply

1 Comment on "Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server"

Notify of
avatar
Sort by:   newest | oldest | most voted
Gaurav Shrivastava
Guest

Thanks for this article, it helps me lot.Keep posting

wpDiscuz