Comments
Sort by recent activity
This server has been monitored by SQL Monitor since November and the job, which coincidently happens to be a t-log backup using SQL Backup, runs every 15 minutes, usually in less than 10 seconds. / comments
This server has been monitored by SQL Monitor since November and the job, which coincidently happens to be a t-log backup using SQL Backup, runs every 15 minutes, usually in less than 10 seconds.
I had the same issue several weeks ago and, although I received no explanation from support as to the why, restarting the SQL Monitor service resolved it and it hasn't occurred since. / comments
I had the same issue several weeks ago and, although I received no explanation from support as to the why, restarting the SQL Monitor service resolved it and it hasn't occurred since.
Unfortunately, I'm considering pulling the plug on SQL Monitor too. I've been working through a variety of connection issues over the last 4-5 weeks. We solved 1. The others are still occurring intermittently. We don't have that many servers to monitor (25) and SQL Response has worked fine as an alerting solution for us. SQL Monitor just doesn't seem robust enough yet and I can't be sure it will reliably send alerts or stay connected to the servers that I am monitoring. / comments
Unfortunately, I'm considering pulling the plug on SQL Monitor too. I've been working through a variety of connection issues over the last 4-5 weeks. We solved 1. The others are still occurring ...
I disabled the monitoring of the cluster as soon as I saw how it was presented in SQL Monitor. I don't want to see the Windows cluster and the nodes. I prefer to have it displayed as it is in SQL Response, which shows me the SQL Server instance. In this example, that would be BRDvSVRSQL40. / comments
I disabled the monitoring of the cluster as soon as I saw how it was presented in SQL Monitor. I don't want to see the Windows cluster and the nodes. I prefer to have it displayed as it is in SQL...
It is on the same domain. I currently monitor this clustered instance using SQL Response on a different monitoring server. The new monitoring server on which I have SQL Monitor installed is Windows Server 2008 R2. / comments
It is on the same domain. I currently monitor this clustered instance using SQL Response on a different monitoring server. The new monitoring server on which I have SQL Monitor installed is Windo...
Thanks. I was looking for a view of alert information that had the T-SQL date, but didn't see one. I looked at Alert_Current. This will help a lot. I didn't know anything about Unix epoch time until yesterday. / comments
Thanks. I was looking for a view of alert information that had the T-SQL date, but didn't see one. I looked at Alert_Current. This will help a lot. I didn't know anything about Unix epoch time ...
I following your instructions for putting the exclusions on one line. The area in SQL Monitor where you place the exclusions only will hold so many characters before it wraps to the next line. THis does appear to be working though. Maybe the use of the | between each exclusion item resolves this. Thanks. / comments
I following your instructions for putting the exclusions on one line. The area in SQL Monitor where you place the exclusions only will hold so many characters before it wraps to the next line. TH...
OK. I was able to exclude the Database Mail queries by adding the sp_readrequest entry, so this does work for that. / comments
OK. I was able to exclude the Database Mail queries by adding the sp_readrequest entry, so this does work for that.
I added ^[Ww]omaster ?. I previously had \bWomaster\b. I'm still receiving alerts. This is the full SQL process fragment. Thanks.
SELECT "dbo"."Womaster"."WO #" FROM "dbo"."Womaster" ORDER BY "dbo"."Womaster"."Date Entered" DESC / comments
I added ^[Ww]omaster ?. I previously had \bWomaster\b. I'm still receiving alerts. This is the full SQL process fragment. Thanks.
SELECT "dbo"."Womaster"."WO #" FROM "dbo"."Womaster" ORDER BY "...
So far, I have the following in the exclusion list. I continue to receive alerts for the long queries involving Womaster.
Database Mail
Womaster|"Womaster"
\bWomaster\b
RESTORE VERIFYONLY
SQLBackup
DatabaseMail90
FROM "dbo"."Womaster"
sp_readrequest
SELECT "dbo"."Womaster"."
^[Ww]omaster ? / comments
So far, I have the following in the exclusion list. I continue to receive alerts for the long queries involving Womaster.
Database Mail
Womaster|"Womaster"
\bWomaster\b
RESTORE VERIFYONLY
SQLBacku...