I have an issue with Always On Availability Groups In SQL Server 2012.
I installed a replica secondary SQLNODE3. It was fine and everything retrievable form tables but suddenly I found I could not read anything from the database. In Activity Monitor, I see the query is suspended and the wait type is:
HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
I wait for the updating transition for more than day but nothing happened.
I restarted the replica server and created the AG from scratch but still cannot read data.
How can I read from the replica and avoid this wait type?