View Source

The Database Agent sends the database events to the Controller when the agent detects that the listener IP is offline and the availability group replica is disconnected or does not synchronize.

You can view the details of the events on the Databases > Events page. This page displays the event summary, triggered time, and database type.

You can view the following information in the details view:

Summary: Brief information about the event
Details: Properties of the event.
Actions Executed: Executed actions if you have created a policy.

If you do not want the Database Agent to send database events to the Controller, then set the dbagent.event.trigger.enabled property to false at the agent level. This property is enabled by default.

The following database events are supported:

Database	Events
Microsoft SQL Server	`DAYS_SINCE_FULL_BACKUP` `DAYS_NO_FULL_BACKUP` `HOURS_LOG_BACKUP` `BACKUP`
Microsoft SQL Server (Cluster)	`AG_LISTENER_IP_NOT_ONLINE` `AG_REPLICA_DISCONNECTED` `AG_REPLICA_NOT_SYNCHRONIZING` `DAYS_SINCE_FULL_BACKUP` `DAYS_NO_FULL_BACKUP` `HOURS_LOG_BACKUP` `BACKUP`
Azure SQL Managed Instance Cluster	`AG_LISTENER_IP_NOT_ONLINE` `AG_REPLICA_DISCONNECTED` `AG_REPLICA_NOT_SYNCHRONIZING` `DAYS_SINCE_FULL_BACKUP` `DAYS_NO_FULL_BACKUP` `HOURS_LOG_BACKUP` `BACKUP`
Azure SQL	`AG_REPLICA_DISCONNECTED` `AG_REPLICA_NOT_SYNCHRONIZING`

Configure Event Rules

Configure an event rule before you create an alert policy.

Navigate to Databases > Configuration and click Event Rules.
Click Add (+) and specify an event rule name, select the database type and database, and the event type.
You can specify the severity (Warning or Critical) for the Microsoft SQL Server availability group events.
Click OK.

Availability Group Listener IP is Not Online

Description: This event is sent to the Controller when the Availability Group Listener IP is offline.

Severity: You can set the severity to the following severity types:

Type	Description
Warning	Set the warning threshold in minutes.
Critical	Set the critical threshold in minutes.

Custom Event Type: AG_LISTENER_IP_NOT_ONLINE

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`dbCollectorName`	Name of the database collector
`eventRuleName`	Name of the event rule
`eventType`	Name of the reported event
`ipAddress`	Virtual IP address of the availability group listener
`ipSubnetMask`	IP subnet mask for the IPv4 address, if any, that is configured for the availability group listener.
`is_dhcp`	The listener uses a dynamic IP address that is assigned by a server running the Dynamic Host Configuration Protocol (DHCP). DHCP is limited to a single subnet.
`listenerld`	Resource GUID from Windows Server Failover Clustering (WSFC) cluster
`stateDesc`	One of the following states: ONLINE OFFLINE ONLINE_PENDING FAILED
`timeStamp`	Time at which the event is triggered
`violationID`	Unique ID of the violation

Availability Group Replica Disconnected

Description: This event is sent to the Controller when the Availability Group replica is disconnected.

Severity: You can set the severity to the following severity types:

Type	Description
Warning	Set the warning threshold in minutes.
Critical	Set the critical threshold in minutes.

Custom Event Type: AG_REPLICA_DISCONNECTED

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`availabilityGroupName`	Name of the availability group
`connectedStateDesc`	Status of the availability group connection
`dbCollectorName`	Name of the database collector
`disconnectedReplicaHostName`	Host name of the disconnected replica
`eventRuleName`	Name of the event rule
`eventType`	Name of the reported event
`operationalStateDesc`	Operational state of the replica
`recoveryHealthDesc`	Description of recovery health of the databases
`replicald`	ID of the availability group replica
`roleDesc`	Primary or secondary node
`synchronizationHealthDesc`	Description of the replicas: not healthy, partially healthy, or healthy
`timeStamp`	Time at which the event is triggered
`violationID`	Unique ID of the violation

Availability Group Replica Not Synchronizing

Description: This event is sent to the Controller when the Availability Group replica is not synchronizing.

Severity: You can set the severity to the following severity types:

Type	Description
Warning	Set the warning threshold in minutes.
Critical	Set the critical threshold in minutes.

Custom Event Type: AG_REPLICA_NOT_SYNCHRONIZING

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`availabilityGroupName`	Name of the availability group
`connectedStateDesc`	Status of the availability group connection
`dbCollectorName`	Name of the database collector
`disconnectedReplicaHostName`	Host name of the disconnected replica
`eventRuleName`	Name of the event rule
`eventType`	Name of the reported event
`operationalStateDesc`	Operational state of the replica
`recoveryHealthDesc`	Description of recovery health of the databases
`replicald`	ID of the availability group replica
`roleDesc`	Primary or secondary node
`synchronizationHealthDesc`	Description of the replicas: not healthy, partially healthy, or healthy
`timeStamp`	Time at which the event is triggered
`violationID`	Unique ID of the violation

Days Since Full Backup

Description: This event is sent to the Controller when the specified number of days has passed since the last backup.

Severity: You can set the severity to the following severity types:

Type	Description
Warning	Set the warning threshold in days.
Critical	Set the critical threshold in days.

Custom Event Type: DAYS_SINCE_FULL_BACKUP

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`databaseName`	Name of the database
`dbCollectorName`	Name of the database collector
`eventRuleName`	Name of the event rule
`lastBackupTimeStamp`	Time at which the last backup was taken
`nodeName`	Name of the node
`timeStamp`	Time at which the event is triggered
`userName`	User name
`violationID`	Unique ID of the violation

Days Since Last Backup (No Backup)

Description: This event is sent to the Controller when the backup does not occur for the specified number of days.

Severity: You can set the severity to the following severity types:

Type	Description
Warning	Set the warning threshold in days.
Critical	Set the critical threshold in days.

Custom Event Type: DAYS_NO_FULL_BACKUP

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`databaseName`	Name of the database
`dbCollectorName`	Name of the database collector
`eventRuleName`	Name of the event rule
`lastBackupTimeStamp`	Time at which the last backup was taken
`nodeName`	Name of the node
`timeStamp`	Time at which the event is triggered
`userName`	User name
`violationID`	Unique ID of the violation

Hours Since Last Log Backup

Description: This event is sent to the Controller when the specified number of hours has passed since the last log backup.

Severity: You can set the severity to the following severity types:

Type	Description
Warning	Set the warning threshold in hours.
Critical	Set the critical threshold in hours.

Custom Event Type: HOURS_LOG_BACKUP

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`databaseName`	Name of the database
`dbCollectorName`	Name of the database collector
`eventRuleName`	Name of the event rule
`lastBackupTimeStamp`	Time at which the last backup was taken
`nodeName`	Name of the node
`timeStamp`	Time at which the event is triggered
`userName`	User name
`violationID`	Unique ID of the violation

Backup

Description: This event is sent to the Controller when the backup is complete.

Severity: Info

Custom Event Type: BACKUP

While configuring alert policies, you can use the Custom Events panel to add a custom event filter.

Click + and specify the custom event type.

Filter the events by using a combination of the following properties:

Property	Description
`databaseName`	Name of the database
`dbCollectorName`	Name of the database collector
`eventRuleName`	Name of the event rule
`lastBackupTimeStamp`	Time at which the last backup was taken
`nodeName`	Name of the node
`timeStamp`	Time at which the event is triggered
`userName`	User name
`violationID`	Unique ID of the violation