SQL Server Performance Forum – Threads Archive
SQL performance countersHi, I have two sql boxes running on Windows 2000 advanced server. When I open perfmon, I do not have the sql server monitors. Any idea how to add them? Thanks.
Any error in Event Viewer?
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
you can follow the following steps at the command prompt: 1. unlodctr mssqlserver (or instance name) 2. lodctr mssqlserver (or instance name) 3. net stop mssqlserver (or instance name) 4. net start mssqlserver (or instance name) after performing these steps you will be able to see all the counters for SQL Server
youcan validate it with following query: select * from sysperfinfo if it is having records, then the steps were successful. Thanks