Article ID: 196657 - View products that this article applies to.
This article was previously published under Q196657
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.
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:
For more information on the lodctr command, type the following from a command prompt:
For more information on the unlodctr command, type the following from a command prompt:
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.
SQL Server Performance Counters on Clustered SQL ServersSQL Server Performance Monitor counters for the Virtual Server are not present when SQL Server 7.0 is set up with a virtual SQL Server configuration and the passive node has control of the resources. The counters will not be available again to the primary node until the whole cluster is shutdown and restarted. Even then, availability is sporadic.
The SQL Server extension counters must be found when the system initially starts. Since the counters DLL file is located in the \\Mssql\Binn directory for SQL Server 6.5 by default, the counters are never found when the initial system startup takes place because the cluster drive in which SQL Server is installed is not accessible until the MSCS resources are all online.
SQL Server 7.0 already places these counters in the %Systemroot%\System32\ directory so that they are available. To make the Sqlctr65.dll file available, place a copy of the Sqlctr65.dll file in the %Systemroot%\System32 directory. The Sqlctr70.dll file is placed in this directory by default.
For additional information about SQL Server performance counters, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/127207/EN-US/ )Missing Objects and Counters in Performance Monitor
246328WARNING: If you use the following article, read it and compare it to other sections in this Microsoft Knowledge Base article that discuss rebuilding the SQL Server registry entries.
(http://support.microsoft.com/kb/246328/EN-US/ )PRB: SQL Performance Counters May be Missing After MDAC Installation on a Cluster
227662In summary, performance counters on clustered SQL Servers are not always available. When performance counters are available, they are usually only on the primary node if no failover has occurred.
(http://support.microsoft.com/kb/227662/EN-US/ )PRB: SQL Performance Monitor Counters Missing