3 added 160 characters in body
source | link

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

2 added 244 characters in body
source | link

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

http://www.sqlskills.com/blogs/jonathan/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0/

http://technet.microsoft.com/en-us/library/dn135324(v=sql.110).aspx

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

http://www.sqlskills.com/blogs/jonathan/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0/

http://technet.microsoft.com/en-us/library/dn135324(v=sql.110).aspx

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

1
source | link

Look for availability_replica_state_change events in the AlwaysOn_health extended events session. If this session is not running:

ALTER EVENT SESSION AlwaysOn_health ON SERVER WITH (STARTUP_STATE = ON);
ALTER EVENT SESSION AlwaysOn_health ON SERVER STATE = START;

More info:

http://www.sqlskills.com/blogs/jonathan/new-alwayson_health-extended-events-session-in-sql-server-2012-rc0/

http://technet.microsoft.com/en-us/library/dn135324(v=sql.110).aspx