How to get data of SQL Server PerfMon Counters without running Performance Monitor tool?
Posted by Jugal Shah on December 13, 2010
Execute the query againts sys.dm_os_performance_counters DMV to get the result.
SELECT * FROM sys.dm_os_performance_counters
sys.dm_os_performance_counters output
18.520469
73.856621
Like this:
Be the first to like this post.
This entry was posted on December 13, 2010 at 4:11 pm and is filed under SQL Server.
Tagged: Performance Monitor Counter using SSMS. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
