Saturday, February 25, 2012

MS SQL 2000 Server counters problem

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/default.aspx?scid=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
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/default.aspx?scid=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
>
|||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):[vbcol=seagreen]
> 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:
|||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):
>
|||Yes,
Edgardo napisal(a):[vbcol=seagreen]
> Are they both having the same problem?
> "Madroy" wrote:

No comments:

Post a Comment