SELECT * FROM sys.dm_os_performance_counters[caption id="attachment_720" align="aligncenter" width="560" caption="sys.dm_os_performance_counters output"]
[/caption]
Monday, December 13, 2010
How to get data of SQL Server PerfMon Counters without running Performance Monitor tool?
Execute the query againts sys.dm_os_performance_counters DMV to get the result.
[caption id="attachment_720" align="aligncenter" width="560" caption="sys.dm_os_performance_counters output"]
[/caption]
[caption id="attachment_720" align="aligncenter" width="560" caption="sys.dm_os_performance_counters output"]
[/caption]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment