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

• Microsoft SQL Server version 7.0

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..

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 \?

c:\mssql7\binn\unlodctr \?

Additional query words: perfmon

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