SQL Monitor 4.1 monitors host / no longer monitors DB

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

SQL Monitor 4.1 monitors host / no longer monitors DB

Postby tstrieber » Mon Jul 21, 2014 2:09 pm

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.

Image

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.
tstrieber
 
Posts: 2
Joined: Mon Jul 21, 2014 2:01 pm
Location: United States

Postby Evan Moss » Tue Jul 22, 2014 4:20 pm

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
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm

Postby Evan Moss » Wed Jul 23, 2014 5:30 pm

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.
Last edited by Evan Moss on Mon Jul 28, 2014 3:29 pm, edited 1 time in total.
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm

Fixed

Postby tstrieber » Mon Jul 28, 2014 2:21 pm

Great work Evan, thanks!
tstrieber
 
Posts: 2
Joined: Mon Jul 21, 2014 2:01 pm
Location: United States

Postby heidihock » Wed Aug 06, 2014 3:52 am

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.
heidihock
 
Posts: 1
Joined: Wed Aug 06, 2014 3:12 am
Location: Nome Alaska, USA

Postby joffwilliams » Tue Sep 16, 2014 4:40 pm

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!
Jonathan Williams
Database Administrator
City of Spokane, WA
joffwilliams
 
Posts: 13
Joined: Tue Mar 27, 2012 4:10 pm
Location: Spokane, WA

Re: SQL Monitor 4.1 monitors host / no longer monitors DB

Postby freitasm » Thu Sep 25, 2014 10:31 pm

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
 
Posts: 6
Joined: Sun Nov 04, 2012 10:24 pm
Location: New Zealand

Re: SQL Monitor 4.1 monitors host / no longer monitors DB

Postby freitasm » Sat Sep 27, 2014 12:34 pm

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...
freitasm
 
Posts: 6
Joined: Sun Nov 04, 2012 10:24 pm
Location: New Zealand


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests