Red Gate forums :: View topic - SQL Monitor 4.1 monitors host / no longer monitors DB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

SQL Monitor 4.1 monitors host / no longer monitors DB

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
tstrieber



Joined: 21 Jul 2014
Posts: 2
Location: United States

PostPosted: Mon Jul 21, 2014 2:09 pm    Post subject: SQL Monitor 4.1 monitors host / no longer monitors DB Reply with quote

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.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 99

PostPosted: Tue Jul 22, 2014 4:20 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Evan Moss



Joined: 12 Jun 2013
Posts: 99

PostPosted: Wed Jul 23, 2014 5:30 pm    Post subject: Reply with quote

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.
_________________
Evan Moss
Product Support
(866) 627-8107


Last edited by Evan Moss on Mon Jul 28, 2014 3:29 pm; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
tstrieber



Joined: 21 Jul 2014
Posts: 2
Location: United States

PostPosted: Mon Jul 28, 2014 2:21 pm    Post subject: Fixed Reply with quote

Great work Evan, thanks!
Back to top
View user's profile Send private message
heidihock



Joined: 06 Aug 2014
Posts: 1
Location: Nome Alaska, USA

PostPosted: Wed Aug 06, 2014 3:52 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group