Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9317 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
How to resolve the orphan use problem? : sql server security
what is a mixed extent? : Sql server administration
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is a field in a table?
What are the 10 characteristics of data quality?
What command would you use to create an index?
Will sql server 2005 allow you to reduce the size of a column?
How do you create a data source?
What happens if time-only values are provided as date and time literals?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the maximum size of sql server database?
Can binary strings be converted into numeric or float data types?
Explain system scalar functions?
What is self contained sub query?
How is table type constraint applied to a table?
