— Understand the performance of SQL server at macro level
— use sys.dm_os_performance_counters
Counters: sample counters that can be used are:
MSSQL:SQL Errors
MSSQL:SQL Statistics
MSSQL:Locks
MSSQL:Memory Manager
MSSQL:General Statistics
MSSQL:Transactions
MSSQL:Wait Statistics
etc.,
Now the limitation is that all above counters are specific to SQL Server. If you still want to capture relating to disk or network – like physical disk, network interface card, etc then use performance monitor.
0 Comments.