What is blocking and how would you troubleshoot it?
Answer Posted / swapna
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do I trace a query in sql server?
Explain user defined functions?
How to use “drop” keyword in sql server and give an example?
Explain what are partitioned views and distributed partitioned views?
How to bind a view to the schema of the underlying tables?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to filter records of table in SQL SERVER?
which table keeps the locking information? : Sql server administration
What are the difference between primary keys and foreign keys?
What is a user-defined function in the sql server and what is its advantage?
What are distinctive joins find as a part of sql?
What are sql servers used for?
What is sharding?
Tell me what is difference between clustered and non clustered index?
What is the Main Difference between ACCESS and SQL SERVER?