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)

by SSWUG Research

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

Tags:
Author: SSWUG ResearchSSWUG Research is the team that brings you SSWUG-based content and community links. Have an idea? Send us a note at sswugresearch@bitsonthewire.com - we'd love to hear from you.