Alert - DB status

[aachaemenes]

Alert that shows when db status is not online.

[DavidWiseman]

An alert for unusual database states would be useful - offline, recovery pending, suspect, emergency.

[DavidWiseman]

There might be an alert type of this in future, but as a workaround you can always create a SQL Agent job that fails based on the database state. You can do this against the DBA Dash repository database. Something like this.

IF EXISTS(
	SELECT * 
	FROM dbo.Databases D
	JOIN dbo.Instances I ON D.InstanceID = I.InstanceID
	WHERE state IN(3,4,5,6)
	AND D.IsActive=1
	AND I.IsActive=1
	)
BEGIN
	RAISERROR('Database state alert',11,1)
END

DBA Dash can alert on agent job failure.