SQL performance counters | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL performance counters

Hi, 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?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
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
DJ
Thank you.
]]>