Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 1 Answers
- 7129 Views
- I also Faced
- E-Mail Answers
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 |
How do you create a clustered index?
Why and when do stored procedure recompile?
What is difference between clustered and non clustered index?
Why use sub query in sql server and list out types of sub queries?
whats new about truncate in sql server 2008?
0 Answers MedSave Healthcare, Serco,
What is difference between createstatement and preparedstatement?
How to create indexed view?
What are the advantages of user defined function?
Why should you use or avoid select * statements?
How to get number of days in a given year?
Explain what is lock escalation?
What are sql dirty pages?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
