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?
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