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 attribute relationships, why we need it? : sql server analysis services, ssas
What is schemabinding a view?
Differentiate sql server reporting services vs. Crystal reports?
What is normalization? What number of normalization shapes are there?
How to enforce security in sql server? : sql server security
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is the difference between stored procedure and user defined functions?
What is log shipping?
What is the default port for SQL Server over a firewall?
Can we create clustered index on composite key?
Why is replication required on the sql server?
What is the difference between ddl,dml and dcl commands?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How to generate create table script on an existing table in ms sql server?
How to create a simple table to test triggers in ms sql server?
