Average Latch Wait Time
-
Hi all,
Please can someone tell me what average latch wait time is? I have downloaded a tool from the internet (Idera SQL Check) and it displays average latch wait time, and I was just wondering what that meant?
Thanks,
Paula.
-
It tells you the average time that any process had to wait for latches. Latches are short-term syncronization objects. Note that it only includes those times when a process actually had to wait for a latch. See this article for info on Locks vs Latches.
-
Latches are very lightweight, short-term synchronization objects protecting actions that need not be locked for the life of a transaction. They are primarily used to protect a row when read for a connection.
When the relational engine is processing a query, each time a row is needed from a base table or index, the relational engine uses the OLE DB API to request that the storage engine return the row. While the storage engine is actively transferring the row to the relational engine, the storage engine must ensure that no other task modifies either the contents of the row or certain page structures such as the page offset table entry locating the row being read. The storage engine does this by acquiring a latch, transferring the row in memory to the relational engine, and then releasing the latch.
SQL Server Performance Monitor has a Latches object that indicates how many times latches could not be granted immediately and the amount of time threads spent waiting for latches to be granted.
-
Thanks for all of this. Very useful and informative.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply