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
>
>.
>
Friday, March 23, 2012
No data in SYSPERFINFO table of Master DB
Labels:
access,
collecting,
database,
master,
microsoft,
monitors,
mysql,
oracle,
performance,
run,
server,
sql,
sysperfinfo,
table,
tracked
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment