Sql Server Always On Monitoring

miniDBA monitors your Always On Databases

sql server performance tuning

Replica Performance

The Always On Dashboard in miniDBA Desktop shows the following replica performance metrics:
  • KB Sent and Received
  • Messages Sent and Received
  • Flow Control Milliseconds
  • Sync/Recovery health and operations/connected states
sql server performance tuning

Database Performance

The Always On Dashboard in miniDBA Desktop shows the following database performance metrics:
  • Mirrored Write Transactions/sec
  • Transaction Delay Ms
  • Log Send Queue Size
  • Sync health and sync/database states

Alerts

The following alerts are part of the standard monitoring setup for miniDBA that shows UI alerts and sends emails:
  • Always On Failed To Start
  • Always On Failover
  • Always On Replica Unhealthy
  • Always On Database Unhealthy
  • Always On Transaction Delay Too Long