October 8, 2015 at 9:57 am
can any one provide the queries to check the errors in always on in sql 2012/2014 ?
October 9, 2015 at 4:46 am
Errors are likely to be in the error log, but there are a number of DMVs that are useful for observing behavior, especially retry rates, etc.
sys.dm_hadr_availability_replica_states
sys.dm_hadr_database_replica_states
sys.dm_tcp_listener_states
You can also gather information from Perfmon Counters
SQL Server:Availability Replica
Bytes Sent to Replica/sec
Flow Control Time
Resent Messages/sec
SQL Server:Database Replica
Log Bytes Received/sec
Log Send Queue
Recovery Queue
Transaction Delay
Mirrored Write Transactions/sec
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply