Best Resolution for Error 601 [Resolved]

Posted by Bandi under Sql Server on 6/24/2014 | Points: 10 | Views : 472 | Status : [Member] [MVP] | Replies : 2
How to resolve the below error in SQL Server 2012 and what is the cause for this error.
"could not continue scan with nolock due to data movement sql server 2012"


Do you people faced this kind of error in your work ?

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif



Responses

Posted by: Bandi on: 6/30/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down

Resolved
I had the above error while SQL server Agent Job runs.... So i have restarted job at failed step because we have SELECT statements with NOLOCKs....

I have followed first solution in the RESOULTION list( see above post)

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Bandi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 6/24/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Researching on the above error, I have found the following recommendations:
Resolution
Unless the database has been explicitly marked as ‘read only’ there is no way to guarantee that there are no data modification operations going on.
The possible solutions are:
1. Check for 601 errors from the application and retry the query automatically if the error occurs.
2. Improve the indexes supporting the query or modify the query so that it has a smaller lock footprint and runs more quickly. If the query touches less data it will be less likely to encounter the problem.
3. Avoid use of NOLOCK hint and if necessary have a retry logic 601 error . Improving the indexes as mentioned above might make it possible to get this data without doing large scans that would be likely to cause blocking.
If you don’t use NOLOCK hint or to READ UNCOMMITTED Isolation level then check the database for corruption (Dbcc checkdb)

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Bandi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response