Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
While locking is esse
ntial to support concurrent read and write activities on a database, blocking can adversely affect system performance. Learn how to optimize your SQL Server database to minimize blocking, and see how you can monitor the system to better understand how locking impacts performance.
The April issue of TechNet Magazine has a lot more on SQL Server. Check it out.