Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Time-out occurred while waiting... Reset to device

Author  Topic  azoppe Starting Member 1 Post Posted - 2013-03-24 : 01:07:20 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!