magritton
7/4/2015 - 12:03 PM

SQL DMV OS performance counters. Used to get the CPU usage and other stats in relation ship to the various instances. I used this to get the

SQL DMV OS performance counters. Used to get the CPU usage and other stats in relation ship to the various instances. I used this to get the default pool CPU usage to test the performance alerts.

SQL DMV OS Performance.sql
content_copyfile_download
select * from sys.dm_os_performance_counters
where object_name like '%pool%'
and instance_name = 'default'
and counter_name like '%CPU%'