Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhofing
Starting Member
15 Posts |
 Posted - 2004-06-04 : 09:42:31
|
| I am running SQL 2000 on a W2K box (setup by someone else who is no longer here). I start up the Performance Monitor and the SQL counters are missing (various others are available).The application log contains the following message:The configuration information of the performance library "C:\WINNT\system32\w3ctrs.dll" for the "W3SVC" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted. I am not sure if this message is indicative of the problem as it not pointing the the SQL counters DLL file but it appears every time I start the Performace Monitor.Can anyone tell me how to correct this?Thanks!Ric |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-04 : 12:54:57
|
| Go to:http://support.microsoft.comSearch on SQL performance counters missing. Go through all of the articles and find the one that matches your environment and problem, then implement the solution. The reason why we can't give you a definitive answer is that there are various resolutions to this problem, so the Q articles need to be read through by the individual.Tara |
 |
|
|
rhofing
Starting Member
15 Posts |
Posted - 2004-06-04 : 14:40:30
|
| Tara, I actually already did this (my bad, I should have mentioned it in my original post) and I was only able to find one pertinent article. Unfortunately none of the suggestions helped, or did not apply to SQL2000.Ric |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-04 : 14:44:23
|
| You might consider reapplying service pack 3a for SQL 2000 and sp4 for Win2k.Tara |
|
|
|
|
|
|
SQL performance counters missing