November 19, 2015 at 2:09 am
We are facing issue to connect second replica and databases are in not sync
we checked in logs and found
A time-out occurred while waiting for buffer latch -- type 4, bp 000000028122A440, page 4:1, stat 0x10b, database id: 2, allocation unit Id: 6488064, task 0x0000000FBBE31088 : 0, waittime 300 seconds, flags 0x1000000039, owning task 0x000000110D77D088. Not continuing to wait.
how to resolve the issue ?
November 19, 2015 at 7:31 am
Hard to say for sure without a lot more detail, but it looks like you have a server with some memory stress which is leading to timeouts with your Availability Group.
"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
November 19, 2015 at 7:36 am
check this if it helps.
http://mssqlwiki.com/tag/a-time-out-occurred-while-waiting-for-buffer-latch/
SQL DBA.
November 19, 2015 at 10:04 pm
Try the following query
SELECT TOP 40 *
FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC
Or
Read the following resource
https://support.microsoft.com/en-us/kb/2545989
http://www.sqlservercentral.com/Forums/Topic1150864-391-1.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply