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:

DatabaseEvents
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.

  1. Navigate to Databases > Configuration and click Event Rules.

  2. 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.

  3. 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:

TypeDescription
WarningSet the warning threshold in minutes.
CriticalSet 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.

  1. Click + and specify the custom event type.

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

    PropertyDescription
    dbCollectorNameName of the database collector
    eventRuleNameName of the event rule
    eventType

    Name of the reported event

    ipAddressVirtual IP address of the availability group listener
    ipSubnetMaskIP 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.

    listenerldResource GUID from Windows Server Failover Clustering (WSFC) cluster
    stateDesc

    One of the following states:

    • ONLINE
    • OFFLINE
    • ONLINE_PENDING
    • FAILED
    timeStampTime at which the event is triggered
    violationIDUnique 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:

TypeDescription
WarningSet the warning threshold in minutes.
CriticalSet 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.

  1. Click + and specify the custom event type.

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

    PropertyDescription
    availabilityGroupNameName of the availability group
    connectedStateDescStatus of the availability group connection
    dbCollectorNameName of the database collector
    disconnectedReplicaHostNameHost name of the disconnected replica
    eventRuleNameName of the event rule
    eventType

    Name of the reported event

    operationalStateDescOperational state of the replica
    recoveryHealthDescDescription of recovery health of the databases
    replicald

    ID of the availability group replica

    roleDescPrimary or secondary node

    synchronizationHealthDesc

    		Description of the replicas: not healthy, partially healthy, or healthy
    timeStampTime at which the event is triggered
    violationIDUnique 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:

TypeDescription
WarningSet the warning threshold in minutes.
CriticalSet 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.

  1. Click + and specify the custom event type.

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

    PropertyDescription
    availabilityGroupNameName of the availability group
    connectedStateDescStatus of the availability group connection
    dbCollectorNameName of the database collector
    disconnectedReplicaHostNameHost name of the disconnected replica
    eventRuleNameName of the event rule
    eventType

    Name of the reported event

    operationalStateDescOperational state of the replica
    recoveryHealthDescDescription of recovery health of the databases
    replicald

    ID of the availability group replica

    roleDescPrimary or secondary node

    synchronizationHealthDesc

    		Description of the replicas: not healthy, partially healthy, or healthy
    timeStampTime at which the event is triggered
    violationIDUnique 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:

TypeDescription
WarningSet the warning threshold in days.
CriticalSet 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.

  1. Click + and specify the custom event type.

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

    PropertyDescription
    databaseNameName of the database
    dbCollectorNameName of the database collector
    eventRuleNameName of the event rule

    lastBackupTimeStamp

    		Time at which the last backup was taken
    nodeNameName of the node
    timeStampTime at which the event is triggered
    userNameUser name
    violationIDUnique 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:

TypeDescription
WarningSet the warning threshold in days.
CriticalSet 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.

  1. Click + and specify the custom event type.

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


    PropertyDescription
    databaseNameName of the database
    dbCollectorNameName of the database collector
    eventRuleNameName of the event rule

    lastBackupTimeStamp

    		Time at which the last backup was taken
    nodeNameName of the node
    timeStampTime at which the event is triggered
    userNameUser name
    violationIDUnique 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:

TypeDescription
WarningSet the warning threshold in hours.
CriticalSet 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.

  1. Click + and specify the custom event type.

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

    PropertyDescription
    databaseNameName of the database
    dbCollectorNameName of the database collector
    eventRuleNameName of the event rule

    lastBackupTimeStamp

    		Time at which the last backup was taken
    nodeNameName of the node
    timeStampTime at which the event is triggered
    userNameUser name
    violationIDUnique 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.

  1. Click + and specify the custom event type.

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

    PropertyDescription
    databaseNameName of the database
    dbCollectorNameName of the database collector
    eventRuleNameName of the event rule

    lastBackupTimeStamp

    		Time at which the last backup was taken
    nodeNameName of the node
    timeStampTime at which the event is triggered
    userNameUser name
    violationIDUnique ID of the violation