My Favorite Blogs

Wednesday, October 7, 2009

SQL PerfMon Counters Missing

SQL Server Performance Monitor Counters are Missing
To solve this problem follow the following steps:
Stop SQL Server Service
Open Command Prompt (Start – Run – Cmd)
Run the command: NET STOP MSSQLSERVER
Then, this question will appear: “The following services are dependent on the SQL Server (MSSQLSERVER) service. Stopping the SQL Server (MSSQLSERVER) service will also stop these services: SQL Server Agent (MSSQLSERVER). Do you want to continue this operation? (Y/N) “
Press “Y”
Open Command Prompt and get located on the BINN directory of SQL Server. Probable locations are:
c:\Program Files\Microsoft SQL Server\90\Tools\Binn
c:\Program Files\Microsoft SQL Server\80\Tools\BINN
Once located on the BINN directory, using the Command Prompt, execute the following command: lodctr sqlctr.ini
Restart your computer.

No comments:

Post a Comment