SQL Monitor 4.1 monitors host / no longer monitors DB

tstrieber

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.

Evan Moss

Hello,

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

Evan Moss

For anyone else looking at this post, restarting the Base Monitor service seems to have solved it. It looked like it was related to a WMI outofmemory error.

tstrieber

Great work Evan, thanks!

heidihock

I was trying to find out some answers and I got it here. Thanks for this! I have the same error as I was upgrading it. I really dont have any idea what went wrong. I will try to configure it now.

joffwilliams

I had the opposite issue - all instances within a cluster were reporting metrics, but I had nothing for one of the cluster nodes (the other was fine). Restarting the base monitor fixed it. Thanks!

freitasm

I've updated to 4.1 yesterday after updating SQL 2012 with SP2 on the monitoring server. Not getting any data in Genera, Buffer cache, Memory, Latches and Locks or host memory/CPU utilisation... But Top 10 waits and Top 10 queries seem to be working.

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?

freitasm

Hmmm. Installed SP2 and Cumulative Updates on SQL Server and after rebooting the server SQL Monitor picked it up and all numbers are showing again...

hayko1998

I am using Trial version of SQL Monitor 4.1.i can see only system databases. No user db visible. Any ideas why?

chriskelly

Is it possible that the user account you are using for monitoring the SQL Server instance only has permissions to view the system databases? Or some variation of permissions which does not give it full access?

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

hayko1998

I am using windows Administrator account

chriskelly

A windows admin account doesn't necessarily have full permissions on a SQL Server instance, so it is still worth double checking.

hayko1998

Hi Red Gate
I would like to know how to monitor and detected Deadlocks using SQL Monitor 4.1