when we are executing query in sql server 2005(SP2) we are getting below error.
A time-out occurred while waiting for buffer latch -- type 2, bp 03BD8650, page 1:15883707, stat 0x1c0040d, database id: 7, allocation unit Id: 72057608604745728, task 0x54FA8118 : 5, waittime 300, flags 0x3a, owning task 0x009291F8. Not continuing to wait.
Memory Utilization is also looking normal.
please let me know how to avoid this problem and provide me if any article is available.
View Complete Post