SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Time-out occurred while waiting... Reset to device
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

azoppe
Starting Member

Argentina
1 Posts

Posted - 03/24/2013 :  01:07:20  Show Profile  Reply with Quote
Hi guys and girls, I hope you can help me.

I´m running SQL2005 since a couple of years on server, and receantly, with no reason, I´m having some kind of problem with query execution. I´m getting two kind of errors:

"Time-out occurred while waiting for buffer latch type 2 for page (3:210666), database ID 9." and
"Could not continue scan with NOLOCK due to data movement". That last message is showed when I use with (nolock) option.
Generally occurs when I use large size tables as the source.

Looking on system event log, everytime I get the SQL errore, I see a warning that says "Reset to device, \Device\RaidPort0, was issued". Could be a IO issue?

Any ideas? Thanks!
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000