June 6, 2005 at 5:06 pm
As crazy as it sounds, it was fine before I changed the Server account from local to a domain account. This is the 4th server it has happened to me on. When I go to setup alerts there is no SQL server performance condition alerts. Something wiped the sysperfinfo table on me. All the SQL servers are 2000 SP3 they run on either W2K or W3K.
Barring a resolution to this problem, is there a way to the counters back? Would service packing it work?
Thanks
Frank
June 7, 2005 at 12:54 am
This happens if SQL Server is restarted while System Monitor is open. You probably also have an error message in the error log that says something about failing to access shared memory or similar. Close sysmon and then restart the server.
June 7, 2005 at 8:54 am
Chris,
I did find that error. I will try that, thanks
Frank
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply