1 SELECT [counter_name] ,
2 "CPU Time:Total(ms)" ,
3 "CPU Time:Requests" ,
4 "Elapsed Time:Total(ms)" ,
5 "Elapsed Time:Requests"
6 FROM ( SELECT [counter_name] ,
7 [instance_name] ,
8 [cntr_value]
9 FROM sys.dm_os_performance_counters --计数器视图
10 WHERE OBJECT_NAME LIKE '%Batch Resp Statistics%'
11 ) os_pc PIVOT( AVG([cntr_value]) FOR [instance_name] IN ( "CPU Time:Total(ms)",
12 "CPU Time:Requests",
13 "Elapsed Time:Total(ms)",
14 "Elapsed Time:Requests" ) )AS Pvt;
1 SELECT COUNT (*) FROM sys.dm_os_performance_counters
