What is lock escalation?
Answer / swapna
Lock escalation is the process of converting a lot of low
level locks (like row locks, page locks) into higher level
locks (like table locks). Every lock is a memory structure
too many locks would mean, more memory being occupied by
locks.
To prevent this from happening, SQL Server escalates the
many fine-grain locks to fewer coarse-grain locks. Lock
escalation threshold was definable in SQL Server 6.5, but
from SQL Server 7.0 onwards it's dynamically managed by SQL
Server.
Is This Answer Correct ? | 6 Yes | 1 No |
What is an execution plan? How would you view the execution plan?
How to handle error or exception in sql?
What is after dml trigger?
What is dbcc? Give few examples.
What do you mean by tablesample?
How do I find the default sql server instance?
What is replace and stuff function in sql server?
What is an expression in ms sql server?
Explain few examples of RDBMS?
What happens on checkpoint?
what is the system function to get current user's user id? : Sql server database administration
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?