Try our conversational search powered by Generative AI!

Re-organize SQL Server indexes and why ALLOW_PAGE_LOCKS is OFF?



Our SQL Server admin tried to set up jobs for re-organizing/re-building sql server indexes for our epi commerce databases. Found out that ALLOW_PAGE_LOCKS was set to OFF for indexes, which means they cannot be re-organized (only re-built). A nightly job re-organizing indexes otherwise seems like a good thing to do.

I guess there is a reason for this (guessing dead lock issues?) and wonder if it is safe to  set ALLOW_PAGE_LOCKS = ON for all indexes?

Thanks for your input :-)
/ Markus

Oct 24, 2012 11:56
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.