question

Sakthivel avatar image
Sakthivel asked

SQL Error Message

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.
sqlerror-message
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sakthivel avatar image Sakthivel commented ·
Thank You fro your respose Mr.Pavel i will check and fix that error,,,,,,
0 Likes 0 ·
Sakthivel avatar image Sakthivel commented ·
Hi Mr.Pavel In that above error every day occur after that i restart the sql server it's work correctly i dont know how can i resolve this error can you please send me details,,,,,,,,,,,,,,,
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
this url meets your requirement http://www.sql-server-performance.com/2006/error-messages-heavy-load/
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sakthivel avatar image Sakthivel commented ·
Thank You for your reponse
0 Likes 0 ·
Sakthivel avatar image Sakthivel commented ·
Hi Mr.ramesh In that above error every day occur after that i restart the sql server it's work correctly i dont know how can i resolve this error can you please send me details,,,,,,,,,,,,,,,
0 Likes 0 ·
viikiseth avatar image
viikiseth answered
Please refer below link . this may help you http://support.microsoft.com/kb/940942
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.