[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
SQL Performance Counters are Missing

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

SQL Server Performance Monitor Counters are Missing

To solve this problem follow the following steps:

  1. Stop SQL Server Service
    1. Open Command Prompt (Start – Run – Cmd)
    2. Run the command:  NET STOP MSSQLSERVER
    3. 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) “
    4. Press “Y”
  2. Open Command Prompt and get located on the BINN directory of SQL Server.  Probable locations are:
    1. x:\Program Files\Microsoft SQL Server\90\Tools\Binn
    2. x:\Program Files\Microsoft SQL Server\80\Tools\BINN
  3. Once located on the BINN directory, using the Command Prompt, execute the following command:  lodctr sqlctr.ini
  4. Restart your computer.

Applies to:  SQL Server 2000 y SQL Server 2005.




 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.