Posts
Sort by recent activity
Erroneous Log Backup Overdue alerts
Occasionally we seem to receive log backup overdue alerts when we should not.
The alerts are raised as "Medium" which we have set to 3 hours. However the alerts are always raised at 6:20AM and then...
Feature request: Alert CSS popup
Hi,
A handy addition to SQL Monitor would be a css popup, containing a summary of alert details, on the alerts inbox page.
i.e. for Backup overdue show db name, last backup date etc. This would pot...
SQL Query Fragment
Hi,
In the deadlock event often I see the language event as something like...
"Language Event: (@p0 datetime,@p1 int,@p2 int,@p3 int,@p4 int,@p5 int,@p6 int,@p7 int,@p8 int,@p9 int,@p10 int,@... in...
Maintenance Window & Log backup Overdue
Hi,
I recently upgraded to 2.2 to implement a maintenance window from 4:10AM - 6:10AM to get rid of a few alerts about overdue log backups.
We backup our logs hourly apart from 5AM where a full bac...
Job duration unusual alert
Hi Guys,
The "Job duration unusual" alert includes job failures in the baseline. For the purposes of this alert wouldn't it make more sense to ignore these failures when calculating the baseline?
I...
Time range for alerts
Hi,
It would be useful if we could configure alert rules to only apply to certain time ranges.
For example, On one of our server we do log backups on the hours, every hour apart from 5AM where a fu...
Global Overview show OK when connection has failed
Hi,
Some recent firewall changes meant SQL Monitor was unable to connect to a couple of our SQL boxes.
The Global Overview page shows @OK' for the server & SQL instance (but no data for CPU & memor...
Long-running query
We've had loads of alerts raised for a stored procedure we know never takes more than 2 seconds. Alerts are set for > 60 seconds.
If the connection is reused will SQL Monitor identify multiple exec...
Performance impact of Redgate SQL Monitor
Hi,
Have Redgate ran any load tests with & without SQL monitor. Do you have any figures as to the performance impact of SQL Monitor?
Rhys
Perfmon Bad data error
I get the following error on one of our server...
Perfmon data is missing objects: SQLServer:Access Methods, SQLServer:Buffer Manager, SQLServer:Databases, SQLServer:General Statistics, SQLServer:L...