Activity overview
Latest activity by johnmcp
Got it. Thanks Chris / comments
Got it. Thanks Chris
Links in email alerts incorrect
I recently changed from the built in web server hosted on the same server as the base monitor to an IIS web server on a different server than the base monitor. Problem is, the email alerts which us...
In my case, the problem was lack of resources on the base monitor server. The process which adds the detail to the mail was timing out. I added some extra memory to the server and the problem has been resolved. / comments
In my case, the problem was lack of resources on the base monitor server. The process which adds the detail to the mail was timing out. I added some extra memory to the server and the problem has b...
Detail missing from email alerts
For some reason the email alerts I am receiving are missing the detail they usually have. It seems to have reverted back to the way they were pre Version 3.3.
I am currently running 4.0 but I had t...
If anyone is interested I used the script below: DECLARE @Alerts TABLE (AlertId INT, Date BIGINT)
INSERT INTO @Alerts
( AlertId, Date )
SELECT A.AlertId, ASev.Date
FROM alert.Alert A INNER JOIN alert.Alert_Severity ASev ON A.AlertId = ASev.AlertId
INNER JOIN alert.Alert_Type AType ON A.AlertType = AType.AlertType
WHERE A.TargetObject LIKE '%<[i]server/cluster name[/i]>%'
AND AType.Name = '<[i]alert type[/i]>'
INSERT INTO alert.Alert_Cleared
( AlertId, Date, Cleared )
SELECT A.AlertId, A.Date, 1
FROM @Alerts A
UPDATE alert.Alert SET [Read]=1
WHERE AlertId IN
(SELECT AlertId from @Alerts)
/ comments
If anyone is interested I used the script below:DECLARE @Alerts TABLE (AlertId INT, Date BIGINT)
INSERT INTO @Alerts
( AlertId, Date )
SELECT A.AlertId, ASev.Date
FROM aler...
Script to clear alerts
Does anyone have a SQL script that I can run against the SQL Monitor database to clear alerts?
I have over 600k uncleared alerts for a particular server and it is bogging down the web application a...
I would say that its not ideal to have it this way given that a backup can be taken on any member of an availability group depending on the backup preferences. I do not want to disable the alert on servers that are not performing backups currently because they may change roles at some point and become the preferred backup server.
I would suggest that this alert first check the function sys.fn_hadr_backup_is_preferred_replica to check that the server is specified as a backup server for the replica. / comments
I would say that its not ideal to have it this way given that a backup can be taken on any member of an availability group depending on the backup preferences. I do not want to disable the alert on...
Hi Chris,
Although I can add the Availability group, I get backup overdue messages for the members that are not performing backups. Is this expected behavior for SQL Monitor? / comments
Hi Chris,
Although I can add the Availability group, I get backup overdue messages for the members that are not performing backups. Is this expected behavior for SQL Monitor?
Is it still the case that 2012 HA Groups are not supported in SQL Monitor? / comments
Is it still the case that 2012 HA Groups are not supported in SQL Monitor?