Post reply

Performance Monitor has no SQL Server Objects

  • February 12, 2003 at 2:24 pm

    #158552

    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

    #448794

    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

    #448904

    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

    #449222

    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