PRB: "Event ID (1001) in Source (SQLCTR70) Could Not Be Found"

ID: Q196657

The information in this article applies to:

SYMPTOMS

You may find the following error message in the Windows NT event log:

The description for Event ID (1001) in Source (SQLCTR70) could not be
found. It contains the following insertion string(s): Specified counter
not found in shared memory..

This may indicate problems with the SQL Server 7.0 Performance Monitor counters.


WORKAROUND

To work around this problem, you must remove and reinstall the SQL Server 7.0 Performance Monitor counters. To do this, perform the following steps:

  1. Open a command prompt.


  2. Run the following command to unload the SQL Server 7.0 Performance Monitor counters:
    unlodctr mssqlserver


  3. Close and re-open Performance Monitor; the SQL Server counters should now have been removed from the object list.


  4. Run the following command from the command prompt to load the SQL Server 7.0 Performance Monitor counters again:
    lodctr c:\mssql7\binn\sqlctr.ini


  5. Close and re-open Performance Monitor; the SQL Server 7.0 counters should now appear in the object list.


  6. If the SQL Server 7.0 counters still do not appear in the object list, close Performance Monitor and stop SQL Server 7.0. Then restart SQL Server 7.0 and open Performance Monitor again.



MORE INFORMATION

For more information on the lodctr command, type the following from a command prompt:

c:\mssql7\binn\lodctr \?

For more information on the unlodctr command, type the following from a command prompt:
c:\mssql7\binn\unlodctr \?

Also note that when SQL Server is not running, the SQL Server counters are not available. This is by design, because any instance names, and so on, are not known when SQL Server is not running.

Additional query words: perfmon 


Keywords          : 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbprb

Last Reviewed: April 15, 1999