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

Vote:
 

Hi!

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

#62422
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.