SELECT * FROM sys.dm_os_performance_counters[caption id="attachment_720" align="aligncenter" width="560" caption="sys.dm_os_performance_counters output"]
[/caption]
Showing posts with label Performance Monitor Counter using SSMS. Show all posts
Showing posts with label Performance Monitor Counter using SSMS. Show all posts
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:
Posts (Atom)