SQL Monitor 4.1 monitors host / no longer monitors DB
tstrieber
Posts: 3
SQL Monitor 4.1 monitors the host machine but now fails to monitor the database:
SQL Monitor is no longer monitoring 3 of my 7 databases, instead it only monitors the host machine. I've tried 'retrying the connection' and suspending/enabling the monitoring but nothing has worked.
If I navigate to: "Configuration > Monitored servers > 172.31.250.73\(local)", it tells me that it is connected and there are no errors in the log.
These databases have been monitored fine for at least 6 months. Only after updating to 4.1 have I ran into this problem.
SQL Monitor is no longer monitoring 3 of my 7 databases, instead it only monitors the host machine. I've tried 'retrying the connection' and suspending/enabling the monitoring but nothing has worked.
If I navigate to: "Configuration > Monitored servers > 172.31.250.73\(local)", it tells me that it is connected and there are no errors in the log.
These databases have been monitored fine for at least 6 months. Only after updating to 4.1 have I ran into this problem.
Comments
Thanks for your post and sorry you're experiencing issues with SQL Monitor.
One hypothesis I have is that the account the "SQL Monitor 4 Base Monitor" service is using has changed. (There shouldn't be anything different about the data collection methods between the two versions.)
You can also check on the monitored servers page (in configuration) to see what the failures are. If you hover over the entity that isn't connected, there should be a "show log" link on the right. That should tell you which data collection methods are failing and what the error messages are.
If you'd like to troubleshoot further, we have a ticket open for you (#23640), so feel free to respond to the email you should've gotten from our support system or email support@red-gate.com.
Thanks,
Evan
Product Support
(866) 627-8107
Product Support
(866) 627-8107
Database Administrator
City of Spokane, WA
Restarted the service, checked monitoring settings, restarted the monitoring server and still nothing.
The website is on another machine and was updated to 4.1 at the same time... We have another SQL monitoring tool that is working fine and reporting all those numbers.
Any ideas?
This forum post suggests a query that you can use to see what permissions a user account has on each database. It should help you see whether this is the problem
http://stackoverflow.com/questions/7048 ... a-database
I would like to know how to monitor and detected Deadlocks using SQL Monitor 4.1