What is the Difference Between Latches and Locks in SQL Server

What is latch/locks waits in SQL Server? If you are seeing waits in a wait type of  %latch%, does it mean that the process is waiting to place a Latch on a resource or is it a process waiting on a resource currently has a latch on it? If you are seeing waits with a wait type of %LCK%. Does it mean that the process is waiting to place a lock on a resource that currently has a Lock on it?

The answer is simple. This post will explain the difference between latch and lock and what it does in your page.

Read the rest of the post here: http://blog.sqlauthority.com/2014/03/16/sql-server-what-is-the-difference-between-latches-and-locks/

Leave a Reply

Your email address will not be published. Required fields are marked *