Interested to Buy Any Domain ? << Click Here >> for more details...
What is lock escalation?
- 1 Answers
- 7208 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 |
What is merge statement?
Do you know the isolation level that sql server support?
What are the disadvantages of using the stored procedures?
What is local temp table?
What is exporting utility?
Who developed sql server?
Give a example to search fr a string in all stored procedure in sql server.
What are the type of Indexes? which one is best, why?
Why we use trigger in sql server with example?
Explain what are the authentication modes in sql server?
when you create a database how is it stored? : Sql server database administration
Explain about Normalization?
-
Oracle (3253) - 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)
