No data in SYSPERFINFO table of Master DB

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick (rick.miller_at_fiserv.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 07:19:05 -0500

Has anybody run into the problem on not being able to access SQL performance
monitors. I have tracked it down to the SYSPERFINFO table not collecting any
data. I have worked with Microsoft and they have no idea why this is
happening. I reboot and everything is fine for about a week and then it just
stops....no warning...no nothing.

I have SQL2000 w/SP3a Enterprise running in a cluster. I have reregistered
and rebuilt the counters and ensured that they have been selected using the
exctrlst app.

Just curious.
Rick

Relevant Pages

  • Re: Help: How To Fix Arkanoid PCBs
    ... Apparently I was right about the JAMMA acronym which makes garabaldy a ... shit-head troll. ... Ive probably fixed more monitors than you in my 10+ ... years collecting. ...
    (rec.games.video.arcade.collecting)
  • No data in SYSPERFINFO table of Master DB
    ... One thing I would check -- run sysmon with logging turned ... gathering data every minute or so. ... but I've never corelated that with the SYSPERFINFO table. ... not collecting any ...
    (microsoft.public.sqlserver.server)
  • Re: various pc stuff wanted
    ... I've loads of monitors coming up in a couple of weeks, ... that will be free to good homes, but will need collecting, as I dont ...
    (uk.adverts.computer)