<div>
<div class="content wysiwyg-content">
Recieved this error on a maintenance job to re-origanise indexes.....<br />
<br />
I have tried to find answers online but can't seem to get what I'm looking for.<br />
<br />
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. <br />
It appears Row Level Locking is Enabled Page Level Disabled.<br />
<br />
What is the best option for a table that is used heavily !<br />
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.<br />
<br />
I have seen people saying ENABLE page locking is better but then came across this article<br />
<a href="http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx" rel="ugc">http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx</a><br />
<br />
We are having I/O issues which is seperate to this however just want to know <br />
<br />
For a heavily accessed table should Page locking be enabled or disabled ???<br />
<br />
Thanks<br />
<br />

</div>
</div>


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
http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx

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 ???

Thanks



Page Locking Disabled !

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.