Friday, March 23, 2012

No data in SYSPERFINFO table of Master DB

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.
RickOne thing I would check -- run sysmon with logging turned
on, gathering data every minute or so. Perhaps there's so
much activity that IT isn't collecting the data in a
timely fashion. I've seen that happen on busy systems,
but I've never corelated that with the SYSPERFINFO table.
>--Original Message--
>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
>
>.
>

No comments:

Post a Comment