Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Jonathan Allen

SQLServerCentral.com profile

   Items 1 to 1 of 1   
 

SQL Server CPU Usage History Histogram

Returns a summary of CPU usage by SQL Server over the last 4 hours (default). Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.  Read more...
By Jonathan Allen 2014/07/07 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 2,489 reads
   Items 1 to 1 of 1