Alter index reorganize operation is failing with below error(as page level locking is disabled on few tables)
"The index "[IndexName]" on table "[TableName]" cannot be reorganized because page level locking is disabled."
Now to get rid of this issue,we can enable the page level locking "but" developer don't want to enable the page level locking due to some existing known concurrency issues so as a DBA, I have suggested to perform the maintenance in below order,
1) Enable the page level locking on the tables for which its disabled
2) Run the maintenance plan
3) Disable the page level locking on the tables for which its enabled in step1
Obviously the maintenance will be run during off business hours so other than blocking/resource consumption - will the above steps create any unforeseen issues ? For e.g. recompilation,generation of new execution plans or any other known adverse impact??
Many thanks in advance.. 🙂