Missing SQL performance counters

Home / Uncategorized / Missing SQL performance counters
  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.

http://www.sqlcoffee.com/Tuning02.htm

Napsat komentář

Vaše emailová adresa nebude zveřejněna. Vyžadované informace jsou označeny *