Hi DBA'S, I am a junior DBA in my company and I have an SQL Issue in query Retrieval process. Then i have attached the errors given following can you tell me the suggestion for following error 1) SQL Error Msg 845, Level 17, State 1, Line 2 Time-out occurred while waiting for buffer latch type 2 for page (1:331), database ID 14.
It seems like I/O overload. It could happen that your query was vaiting for locks by some of previous queries which were dooing inserts/updates and eg. the database/log file start growing, I/O was overloaded at that time and a time out occured. You can try to investigate the SQL Server log more deeply whether there are some other messages related to that issue or other messages which were logged at the time of the rror.