One database not collecting stats data

djheath

I am running the latest version of SQL Monitor. I have one database on a SQL 2012 server which isn't getting any stats data collected for it. I received alerts on this database i.e when the log file fills up, but viewing any database metrics under the analysis tab shows the message "No data for the specified time range".

I keep at least one months worth of data in the SQL Monitor database. All other databases show data for the relevant metrics over the same period.

Any idea why I am not getting any metrics for this one database on the server?

djheath

This problem has now rectified itself after the SQL Server was restarted.

mel.abraham

Hi there,

That's great news.

If you have any further problems feel free to email support@red-gate.com.

Kind Regards,

Mel Abraham
Customer Support
Redgate Software