How to Monitor Always On

This blog is based on the monitoring the availability groups, replicas and associated databases by using T-SQL. There are multiple catalogs and dynamic management views (DMV) concerned with Always On availability groups.

Using T-SQL to monitor:

Always On Availability Groups feature on a server instance

Availability groups

Availability replicas

Availability databases

Availability groups listeners.

To monitor the Always On availability groups feature on a server instance

To monitor the Always On availability groups feature on a server instance, use the following built-in function:

Function Used: Serverproperty

Property: IsHadrEnabled, IsClustered

T-SQL

Select serverproperty (‘IsHadrEnabled’)

The result will be either 1 or 0

1 = enabled

0= disabled

Monitoring Availability Groups

To monitor the availability groups for which the server instance hosts an availability replica, use the following views:

Mirza Husain is a senior consultant-database and having more than 10+ years of experience in the IT industry with different domains. He is fond of writing and speaking about SQL Server and also keen to learn new technologies. He is holding MCA degree and having Microsoft certifications as MCP & MCTS. He is also ITIL certified. In his past years, he worked with many clients as Microsoft, Bank of America etc. Currently he is associated with a France based client and offering his best services. You may reach him on his email id -- mirza_dba@outlook.com. Thanks!