Home Forums SQL Server 2008 SQL Server 2008 Administration sql not finishing or stuck RE: sql not finishing or stuck
Sailor
SSCertifiable
Points: 5241
More actions
March 19, 2013 at 7:13 am
#1598410
I think I found part of the problem...which is that the index defrag routine requires page level locking, while the app requires row lock (page lock off). I'm not sure what effect having both page lock on AND row lock on causes, but we will see...