SQL Server, Lock Manager, and “relaxed” FIFO….
An interesting question came in from a customer a few weeks ago. Did SQL Server change its traditional FIFO method for granting locks in SQL Server 2005 and 2008? Although there is no official documentation (not yet, I’ve put in a request to get this changed), the answer to the question is yes.
See the original post:
SQL Server, Lock Manager, and “relaxed” FIFO….
