Troubleshooting Locking
SQL Server locks resources to ensure the logical consistency of the database. Locking in SQL Server is not something that physically affects a data resource such as a row, page, table, or index: It is more like a reservation system that all tasks respect when they want to reserve some resource within the database. Excessive numbers of locks or locks of very long duration can lead to blocking and other problems, but locking by itself may present some issues.
Troubleshooting Lock Memory
You can determine the amount of memory that SQL Server is using for locks by monitoring the Lock Memory (KB) counter in the SQL Server:Memory Manager object in System Monitor (Perfmon). You can change the amount of memory that SQL Server ...
Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
