Category Archives: Perfromance

Locking is the essential because to manage the transaction concurrency in multi-user environment. Locks are in-memory structure of 96 bytes in size which has its owner, resource type, lock modes. SELECT * FROM SYS.DM_TRAN_LOCKS Shared locks(S) SELECT Exclusive Locks(X) During the data modification operators such as insert, update or Delete. This prevent one object toContinue reading “Locks”