Re: Perfmon Counters Missing

Usually just restarting the SQL Server will return the counters. Just make
sure you do not have anything such as perfmon running when you restart. If
that does not work have a look at this:



verify whether the following .DLL resides on your server:

sqlctr80.dll


NOTE: the following commands will require that you stop and restart the
MSSQLServer service. Therfore, you will need to ensure that you have time
blocked out for server down-time.


This file will most likely reside within the \BINN folder on your SQL
Server box. If it exists, you may need to re-register the dll by running
the following from the Run command under the start menu:



regsvr32 "c:\Program files\microsoft sql server\mssql\binn\sqlctr80.dll"
1 ) Stop the SQL Server and restart again.


1.a) Run Perfmon and check if counters appeared. If they appear then OK,
otherwise, close the Perfmon and continue to the next step.



2) On \Program files\microsoft sql server\mssql\BINN\ check that the file
SQLCTR.INI exists. Verify whether it
contains valid contents.

3.1) NOTE: To unload the SQL Counters, use (if counters are corrupt run
this command):


unlodctr MSSQLServer


3.2) And then try reloading them by issuing:


lodctr sqlctr.ini


3.3) Stop the SQL Server and restart again.


3.4) Run Perfmon and check if the counters appear.




--
Andrew J. Kelly SQL MVP


"Thom" <Thom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E090B5C5-E484-45D0-8954-71503548B49F@xxxxxxxxxxxxxxxx
>I have migrated by SQL2000 install to ActiveDirectory from NT40 domain.
> During the process I had to change the agent that runs sql engine. The
> domain of the ID changed. Now I have lost my counters for the sql
> instance
> and don't know where to find them... kind of like the three little pigs
> who
> lost there mittens.
>
> I was hoping that someone here on the board had already resolved an issue
> similar to this.


.

Relevant Pages

  • Re: Performance counter missing
    ... It's a bug that usually happens if you restart SQL Server and have something ... running that is polling the counters at the time you shut down the service. ...
    (microsoft.public.sqlserver.server)
  • Re: Scheduled Backup for SQL Database
    ... Only problem is when the SQL server ... it doesn't restart the agent. ... For some reason the SQL agent under server management ... Look in the SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server statistics Counter
    ... I didn't have the chance to restart the sql server until now, ... So i will try check the error log after restarting the sql server on weekend ... > anything monitoring the counters when you restart. ... >> Threads, Max Worker Threads, Network Threads, Max Network Threads ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Performance Issue
    ... I restarted the SQL ... it's definitely not a good idea to restart SQL Server on regular ... It sounds that you simply were the victim of a poor execution plan. ... When SQL Server first biulds the execition for a function or a stored ...
    (comp.databases.ms-sqlserver)
  • Re: sql performance monitor counters missing !!!
    ... This can happen if you restart sql sever when you have Perfmon running. ... Andrew J. Kelly SQL MVP ... > sql server performance objects counter in the in the server monitor. ...
    (microsoft.public.sqlserver.server)
Loading