SQL Server and MySQL Notes
Pages
(Move to ...)
Home
Contact Me
All Articles
Author Profile
Download Links
How to be DBA?
▼
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.
SELECT * FROM sys.dm_os_performance_counters
[caption id="attachment_720" align="aligncenter" width="560" caption="sys.dm_os_performance_counters output"]
[/caption]
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment