Home > Archive > MS SQL Server > December 2006 > MS SQL 2000 Server counters problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MS SQL 2000 Server counters problem
Madroy

2006-12-13, 7:12 pm

There is a problem with using MS SQL 2000 Server performance counters.
Performance counters for MS SQL aren't visible in perfmon. I've checke
that there is a entry in registry (according to
http://support.microsoft.com/defaul...kb;en-us;152513) and
appropriate dll required to perfmon for MS MSQL seems to be ok.

What can generate this problem ?

Please, advice me,

Regards,
Robert Pater
R_pater@hotmail.com

Edgardo Valdez, MCTS / MCITP

2006-12-13, 7:12 pm

Do you get any results for the following query?

use master
go
select * from sysperfinfo

What service pack is your SQL 2000 server?

"Madroy" wrote:

> There is a problem with using MS SQL 2000 Server performance counters.
> Performance counters for MS SQL aren't visible in perfmon. I've checke
> that there is a entry in registry (according to
> http://support.microsoft.com/defaul...kb;en-us;152513) and
> appropriate dll required to perfmon for MS MSQL seems to be ok.
>
> What can generate this problem ?
>
> Please, advice me,
>
> Regards,
> Robert Pater
> R_pater@hotmail.com
>
>

Madroy

2006-12-13, 7:12 pm

One is SP4, seconf is SP2.
I'm curently off site so I can't run yours query :-(


R

Edgardo Valdez, MCTS / MCITP
<EdgardoValdezMCTSMC...@discussions.microsoft.com> napisal(a):[color=da
rkred]
> Do you get any results for the following query?
>
> use master
> go
> select * from sysperfinfo
>
> What service pack is your SQL 2000 server?
>
> "Madroy" wrote:
>

Edgardo Valdez, MCTS / MCITP

2006-12-13, 7:12 pm

Are they both having the same problem?

"Madroy" wrote:

> One is SP4, seconf is SP2.
> I'm curently off site so I can't run yours query :-(
>
>
> R
>
> Edgardo Valdez, MCTS / MCITP
> <EdgardoValdezMCTSMC...@discussions.microsoft.com> napisal(a):
>
>

Madroy

2006-12-13, 7:12 pm

Yes,

Edgardo napisal(a):[color=da
rkred]
> Are they both having the same problem?
>
> "Madroy" wrote:
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com