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

Přidat komentář


Upozornění - Můžete použít tytoHTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Better Tag Cloud