Community

Shared page locks can be held until end of the transaction and can cause blocking or performance problems in SQL Server 2000 Service Pack 3 (SP3)

In Microsoft SQL Server 2000 Service Pack 3 (SP3), shared page locks can be held until the end of the transaction. This behavior may lead to blocking or performance problems.

Read More - Register for Free Membership