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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Missing SQL Performance Counters

Author  Topic 

DBAWinnipeg
Starting Member

3 Posts

Posted - 2004-05-26 : 08:00:07
Anyone have any ideas/suggestions on finding out why the SQL Server Performance Monitor Counters are missing?

The environment is

2 Clustered Machines
Windows 2000 Advanced Server
SQL Server 2000 Advanced


All of the other Windows Performance Monitors are there but the SQL Server specific ones are missing.

Help




Thanks in Advance

Colin in da 'Peg

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-05-26 : 08:53:30
Restart the servers and they'll almost definitely be there when they come back up.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

DBAWinnipeg
Starting Member

3 Posts

Posted - 2004-05-26 : 08:55:42
We've tried failing over back and forth with no success.

Thanks for the post though



Thanks in Advance

Colin in da 'Peg
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-05-26 : 08:58:02
Are you up-to-date on your windows patches and SQL Server patches? I had this happen before applying the latest updates. I applied them, rebooted, and haven't had any problems since.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

bmanoj
Starting Member

13 Posts

Posted - 2004-05-26 : 13:01:18
May be [url]http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2271[/url] will help.

Manoj
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-05-26 : 13:08:29
Lots of reasons why they may be missing. Here are a couple of articles how to fix it:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246328
http://support.microsoft.com/default.aspx?scid=kb;en-us;227662

Tara
Go to Top of Page
   

- Advertisement -