Sep200924

Alex

0

Locks and Locking

SELECT
locktype  = CASE
WHEN master..syslocks.type = 1 THEN ‘Exclusive table lock’
WHEN master..syslocks.type = 2 THEN ‘Shared table lock’
WHEN master..syslocks.type = 3 THEN ‘Exclusive intent lock’
WHEN master..syslocks.type = 4 THEN ‘Shared intent lock’
WHEN master..syslocks.type = 5 THEN ‘Exclusive page lock’
WHEN master..syslocks.type = 6 THEN ‘Shared page lock’
WHEN master..syslocks.type = 7 THEN ‘Update page lock’
WHEN master..syslocks.type = 8 [...]

Apr200921

Alex

1

Analyze Locks and Locking in SQL Server 2000

SELECT
 locktype  = CASE
   WHEN master..syslocks.type = 1 THEN ‘Exclusive table lock’
   WHEN master..syslocks.type = 2 THEN ‘Shared table lock’
   WHEN master..syslocks.type = 3 THEN ‘Exclusive intent lock’
   WHEN master..syslocks.type = 4 THEN ‘Shared intent lock’
   WHEN master..syslocks.type = 5 THEN ‘Exclusive page lock’
   WHEN master..syslocks.type = 6 THEN ‘Shared page lock’
   WHEN master..syslocks.type = 7 THEN ‘Update page lock’
   WHEN master..syslocks.type = 8 [...]