Comments
Sort by recent activity
Got it. Thanks Chris / comments
Got it. Thanks Chris
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...
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...
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?