Posts
Sort by recent activity
Did Not Receive Job Duration Alert
I discovered this morning that there was job on one of my monitored servers that had been running for 4 days. I did not receive an alert regarding this. I have received job duration alerts from o...
Logging In To SQL Monitor Website
Is there only one login for accessing the website? It doesn't appear that there is any place to add SQL Monitor accounts, but I thought that I'd ask.
Clock Skew Alert Question
Is it possible that network latency could contribute to clock skew alerts? We've had some issues with time management on our servers that we feel has been resolved, but we still see occasional clo...
Query For Alert History
Do you any queries available to use against the database. I'd be interested in queries for alerts. I put together this one, but the TargetObject column is not very intuitive and if you have any w...
Long-Running Query Alert Doesn't Show Duration
The long-running query alert doesn't show the duration. Is that because we are supposed to just assume that it exceeded the threshold? It would be helpful to know how long it actually took to com...
Issue Monitoring Clustered Servers
I added one of our clustered instances to SQL Monitor and encontered a couple of issues. The SQL Server name is BRDvSVRSQL40. I entered that as the server name on Add SQL Servers To Monitor page,...
Jub Duration Alert Issues
I am seeing an issue with the "Ignore if the job run time is less than ??? seconds" setting. Is doesn't seem to be working. I set it to 30 seconds and I still receive alerts for jobs that complet...
Converting BigInt Date Values
Does anyone know how to use T-SQL to convert the bigint date values in the RedGateMonitor database to datetime? An example would be 634250127993781348 as the date value for an entry in the Alert_S...
Long-running Query Exclusions
I'm not that well versed in RegEx and I'm having a hard time contructing an expression to exclude jobs that have T-SQL containing the word Womaster or "Womaster". Has anyone used this yet and, if ...
Job Status Change - Feature Request
I think it would be really useful to be able to monitor changes to SQL Agent job status, like job creation, enabling and disabling. SQL Sentry has this feature. I'm currently replacing SQL Sentry...