What is live lock and deadlock?
what is Lock escalation?
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
explain the storage models of olap? : Sql server database administration
Mention a few common trace flags used with sql server?
How to use order by with union operators in ms sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
Explain the cursor lock types?
What is indexing and its types?
How to connect a database with sql express.?
Difference between Logical Page and Physical Page in SSRS.
What is sql server 2000 work load governor?
What are different types of raid levels?
how to trace the traffic hitting a sql server? : Sql server database administration
What is the difference between a clustered index and a non-clustered index?
Differentiate sql server reporting services vs. Crystal reports?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain the types of indexes.