Recieved this error on a maintenance job to re-origanise indexes.....
I have tried to find answers online but can't seem to get what I'm looking for.
I know Page Locking is set by default by SQL however I have run a query and discovered that a number of tables have this disabled on the Indexes.
It appears Row Level Locking is Enabled Page Level Disabled.
What is the best option for a table that is used heavily !
I do have locking happening on the DB when a task is being completed that is completed on one of the tables on this list.
I have seen people saying ENABLE page locking is better but then came across this article
We are having I/O issues which is seperate to this however just want to know
For a heavily accessed table should Page locking be enabled or disabled ???