Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9149 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
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is SubQuery in SQL Server 2008
How to find out the list schema name and table name for the database?
What is precedence constraint?
What are commonly used odbc functions in php?
What are a scheduled jobs?
What is meant by indexing files?
What are a database and a data warehouse?
What is data block and how to define data block size?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is transaction server isolation?
How to skip remaining statements in a loop block using continue statements?
How to call stored procedure using http soap?
What is b tree index?
