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)
 Perf Mon

Author  Topic 

M.E.
Aged Yak Warrior

539 Posts

Posted - 2003-03-05 : 15:41:22
Win2k and MSSQL2k

We've been hitting a bottleneck and need to run performance moniter. However when I go to add counters, the SQL counters are not there. On a second server we have, they are there. Is there an option I'm missing?

-----------------------
SQL isn't just a hobby, It's an addiction

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-05 : 16:25:44
Yes there are some DLLs or maybe database objects (I can't remember exactly) that are missing. There is a MS article that describes how to fix this. I can't remember what causes it, but we have run into this on one server and I had run into this at my last job on a couple more servers. I will see if I can find the article.

Tara

Edited by - tduggan on 03/05/2003 16:35:37
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-05 : 16:37:43
So far I can only find information on SQL 6.5:
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;227662[/url]

I remember that we called MS because we couldn't find a knowledge base article and they let us know exactly which one it was. If I can't find it, you might have to call MS for this.

Tara
Go to Top of Page

M.E.
Aged Yak Warrior

539 Posts

Posted - 2003-03-05 : 16:40:33
I've found one thats for both 6.5 and 7.0

We're going through them now.
Thanks Tara

-----------------------
SQL isn't just a hobby, It's an addiction
Go to Top of Page

dtipton
Starting Member

1 Post

Posted - 2003-03-06 : 11:48:41
Can you post the URL please.

Thanks

Go to Top of Page
   

- Advertisement -