Sysperfinfo table empty in a SQL2000 cluster

Question

Sysperfinfo table empty in a SQL2000 cluster

Eric Englebretson

Newbie

Points: 3
More actions
June 7, 2004 at 11:01 am

#83012

I've done some checking on this but everything I find seems to only apply to SQL 6.5/7.0. Does anyone know why the sysperfinfo table in a live SQL 2000 cluster would be empty or what to do about it?
Thanks!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 1

The was a problem introduced in SQL2000 SP3, where the performance counters would not be available if perfmon was running at the time SQL2000 was started.

There are more details in KB article 812915

Eric Englebretson Newbie Points: 3 More actions · Answer 2

That doesn't seem to be it. Perfmon wasn't even up, let alone running when we started the SQL cluster. Any other ideas? So far this seems to be horribly obscure.

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 3

It doesn't have to be Perfmon itself that is running to cause the problem, it can be other forms of monitoring software that hook into the performance counters.

If it is this issue, then there is a Microsoft Hotfix for it.

Eric Englebretson Newbie Points: 3 More actions · Answer 4

Unfortunately, no monitoring software of any sort was running when we started this cluster or the SQL services. At some point we might be able to shut down and restart the SQL services, but it would have to be an early morning type thing.