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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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://qa.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