February 12, 2003 at 2:24 pm
Greetings,
I am trying to monitor a SQL Server running Windows 2000 Advanced Server and SQL Server 2000 Enterprise with Performance Monitor however, the SQL Server Performance Objects are missing. Has anyone seen this before?
Thanks.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 12, 2003 at 3:01 pm
There are a few ways they can disappear but let's start with the simplest possibility. They may have been unreged from server some how.
Open up a command prompt and move to the Binn folder where the Sqlctr80.dll binary can be found (old dos CD stuff, default is C:\Program Files\Microsoft SQL Server\MSSQL\Binn).
Now run
regsvr32 sqlctr80.dll
then check to see if returned. If this does not work check the Event Viewer logs to see if any messages, also let me know if this is a clustered server, or multi-version server (SQL 7 and 2000 on same box).
February 13, 2003 at 10:32 am
Antares, Thanks for the idea. I will try that tonight after I stop services. I attempted once while the services were running and received an error stating that the file "may be in memory" aka in use. I'll repost tomorrow with details of either success or failure.
Thanks again.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2003 at 3:55 pm
Antares was right on with this one. Attempting to register the dll didn't work as normal but replacing the dll and restarting did do the trick. Sorry for the delay in getting back on this one.
Thanks for the help!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply