Re: SQL Performance Objects (sqlctr80.dll)
From: Sebastian K. Zaklada (szaklada-dont-like-spam_at_skilledsoftware.com)
Date: 02/09/04
- Next message: Lance Geeck: "MSDE and ODBC making Connections"
- Previous message: ./dz: "SQL Performance Objects (sqlctr80.dll)"
- In reply to: ./dz: "SQL Performance Objects (sqlctr80.dll)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 10 Feb 2004 00:07:23 +0100
> I cannot see the performance objects in the System
> Monitor. I've verified that 'sqlctr80.dll' exists; and
> even checked the 'Performance' key in the registry
> (HKEY_LOCAL_MACHINE .... Services\{my sql instance}
> \Performance) and it looks comparable to an instance
> running on a different server that DOES present the
> performance objects in System Monitor.
I had this saved somewhere in my KB database...
SQL Server counters will disappear for many
reasons, such as Permission, Server Crash, Registry Modification and Virus.
To work around the symptom, I'd like to provide my suggestions on your
issue. Please take the following actions:
1. You have full permission to access the local folder: C:\Program
Files\Microsoft SQL Server\MSSQL
Make sure that you can access this folder or your current account is
located in local administrator group.
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.
You can open the registry to check if there is a key named "Disable
Performance Counters" valued "1" in:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performanc
e]
If it exists, please delete it
3. Under the register key:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performanc
e]
Make sure the following keys with the value DO EXIST. If not, please create
a new one and add the value.
# Note # : The "Last Counter", "Last Help", "First Help",
"WbemAdapFileSignature",
"WbemAdapFileTime", and "First Counter" values can vary between SQL Server
installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCTR80.DLL "
"Collect"="CollectSQLPerformanceData"
"Open"="OpenSQLPerformanceData"
"Close"="CloseSQLPerformanceData"
"Last Counter"=dword:000016ce
"Last Help"=dword:000016cf
"First Help"=dword:000015bb
"WbemAdapFileSignature"=hex:d1,70,dc,f8,a7,75,5e,e4,9e,e6,dd,91,9e,cd,06,65
"WbemAdapFileTime"=hex:d6,34,9d,95,64,0d,c2,01
"WbemAdapFileSize"=dword:00008238
"WbemAdapStatus"=dword:00000000
"First Counter"=dword:000015ba
4. Unload the SQL Server Counters
In command line, execute "unlodctr MSSQLServer" (Without quotation, the
same as below)
5. Reloading the SQL Server Counters
(1) In command line, locate the current folder to C:\Program
Files\Microsoft SQL Server\MSSQL\BINN
(2) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(1) In command line, execute "net stop mssqlserver"
(2) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System Services)
7. Open Perforam Monitor to check if the counters appear
(1) In command line, execute "perfmon"
(2) Add and check if the counter appear
sincerely,
-- Sebastian K. Zaklada Skilled Software http://www.skilledsoftware.com This posting is provided "AS IS" with no warranties, and confers no rights.
- Next message: Lance Geeck: "MSDE and ODBC making Connections"
- Previous message: ./dz: "SQL Performance Objects (sqlctr80.dll)"
- In reply to: ./dz: "SQL Performance Objects (sqlctr80.dll)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
