SQL Server Performance Forum – Threads Archive

Notify for 1st Failover Event

Hi all,
When we setup an alert based an a WMI event — such as the failover of a database, an alert is created for database failover. Since we have more than 20+, this means that the DBA would be paged 20+ times for one server failover. While I could setup the alerts based on only one database — this would be assuming that all databases failover together — which they might not if something goes wrong, such as if somebody fails over one database by accident but not others. Is it possible to set the alert so that it only pages our DBAs once, for the first database that fails over, instead of for every database?

Are all the databases are linked to each other by any way? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

They’re linked in that they’re all necessary for a certain application. However, they are not linked within sql server. The solution that I came up with was that I created a job that pages us if the databases are not set to primary on the same server and then picked one of the central databases for mirroring pages… so if one database is failed over by mistake, it will page us concerning a database split rather than all the databases failing over.

If you are based on automatic failover, can you set specific databases for manual failover. This way you can reduce the issues of pager. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

I’m not sure that I completely understand. I need all of the databases to fail over automatically since one application was designed around several of them.

]]>