Posts
Sort by recent activity
New Data Collection Monitoring Errors
I installed release 2.2 this morning. Since I installed the update, I've received 67 host machine monitoring or SQL Server monitoring error alerts over a 6 hour period for one of the servers. Whe...
Phantom Alert Escalation
I've noticed that there seem to be a few old alerts for which I continue to receive emails long after they've been cleared. As you can see, this alert is from December and I just received an escal...
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...