• Not sure what question does in the Security forum, since neither locks nor latches has anything to do with security.

    Latches are short-term locks that SQL Server takes for physical operations like reading a page from disk. They are released before the transaction is committed. Locks are always held to the end of the transaction.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]