Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9263 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Do you know exporting and importing utility?
What is etl - extraction, transformation, and loading?
What is the osql utility?
Can sql servers linked to other servers like oracle?
System requirements for sql server 2005 express edition?
What is difference between createstatement and preparedstatement?
Create and insert into temp table in sql server?
How do we synchronize On-Premise SQL server with SQL Azure?
What is create statement?
How many triggers you can have on a table?
How to turn on the mssql api module in php?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is self contained sub query?
What is relationship? What number of sorts of relationship are there?
What happens if the update subquery returns multiple rows in ms sql server?
