SQL Server performance monitoring and alerting
Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer
Every monday for the past month i´ve had to reconnect on a number of servers that are monitored, but not all of them....
the logfile in sqlmonitor shows:
User "sqlmonitor" does not have permission to run DBCC SHOWCONTIG for database 'msdb'.
as mentioned, a simple reconnect and everything is peachy, but its alarming that i lose surveillance every weekend...
in my test cluster, 4 out of 6 sql instances have "monitoring stopped" and 6 out of 8 on my production cluster!
all the windows servers in the cluster are still monitored though...
the permissions for the surveillance account are set up the same for all instances....
Any ideas ?
- Posts: 4
- Joined: Tue Aug 16, 2011 2:40 pm
- Location: Stockholm
I would suggest sending all the log files to email@example.com
especially from around the time this error happens.
- Posts: 532
- Joined: Wed Jan 03, 2007 5:02 pm
Return to SQL Monitor 2
Who is online
Users browsing this forum: No registered users and 0 guests