Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is live lock and deadlock?
what is Lock escalation?

Question Posted / sam

Answers were Sorted based on User's Feedback



What is live lock and deadlock? what is Lock escalation?..

Answer / sagi.rahul

In SQL Server Live Lock occurs when read transactions are
applied on table which prevents write transaction to wait
indefinitely and Deadlocking occurs when two user processes
have locks on separate objects and each process is trying to
acquire a lock on the object that the other process has.

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).

Is This Answer Correct ?    12 Yes 2 No

What is live lock and deadlock? what is Lock escalation?..

Answer / zeeshu

LIVE LOCK: when a process is running but it doesnt do any useful work at all but it consumes the cpu time.


DEADLOCK: IN SIMPLE MEANING when a process is requesting for a resource which is held by some other process,and that process is waiting for the resource which is holding by the previous process,then there is a condition of deadlock....

converting low level lock to high level lock is lock escalation

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is sub-query in sql server?

0 Answers  

Is SET a SQL Keyword?

4 Answers   BitWise,

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

Explain nested join?

0 Answers  

What is Online Index Rebuild Operation?

1 Answers  

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

What does normalization do to data?

0 Answers  

in the physical file layout, where should the transaction log be stored in relation to the data file?

0 Answers  

how can i view structure of table in sql server? tell me that query.

10 Answers  

For more SQL Server Interview Questions Click Here
Categories