Suddenly - No data available for Database and SqlServer grps

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Suddenly - No data available for Database and SqlServer grps

Postby jeffhagen » Mon Feb 13, 2012 11:14 pm

My Sql Monitor was working perfectly for months. Then the base monitor and web server crashed. After they got it backup, the monitor has started performing strangely. It collects machine data at 15 second intervals, but sql server / database data is only collected about once every 15 to 20 minutes. If I click on the 10 minute time range, I get 'no data available'. I've tried restarting all the services, re-creating all the monitored servers, etc. Nothing helps.

Thanks
Jeff
jeffhagen
 
Posts: 1
Joined: Mon Feb 13, 2012 11:08 pm

Postby chriskelly » Wed Feb 15, 2012 8:18 pm

SQL Monitor does use a complex data collection schedule, but your situation sounds a little strange, if I have understood you correctly.

Can you send me the SQL monitor error logs (see link) to support@red-gate.com quoting the ticket number F0057364 in the subject line.

http://www.red-gate.com/supportcenter/c ... LogFilesKB
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron