Life time or age of a Share Exclusive and Update lock in SQL Server

added by subhashpunia
2/4/2010 5:26:28 AM

1 Kicks, 51 Views

Age of shared lock is decided by the isolation level of session. Age of exclusive locks and update locks is always the length of outermost user defined transaction. There is no impact of isolation levels on the life time of these locks.