Types of locking in sql server
Types of locking Locking is the way that SQL Server manages transaction concurrency for multi-user environment. A lock as an in-memory structure is 96 bytes in size. How to check locking or DMV for...
Tagged: Lock escalation
Lock Escalation for Sql Server
Lock escalation is the process of converting many fine-grained locks (such as row or page locks) into table locks. When many locks created on the same table’s row in Same session the Sql Server...
Recent Comments