Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between update lock and exclusive lock?
What are the different authentication modes in sql server? How can it be changed?
What are “phantom rows”?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is the maximum number of index per table?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What are the advantages of policy management?
How do you delete a data source?
Can group by be used without aggregate functions?
What are the instances when triggers are appropriate?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
How to change the ownership of a schema in ms sql server?
What is the difference between the application object and session object?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is inline table-value user-defined function?
