Minimize Blocking in SQL Server

  • Article

While locking is essential 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.