What is blocking and how would you troubleshoot it?
Answer Posted / rajkumar
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.
sp_who2 will give the list of blocking sessions. From that
we can find the objects using dbcc command.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
When to use Inner join & when to use subquery?
What is ms sql server triggers?
Which are ddl commands?
Does the unique constraint create an index?
What are the different types of subquery?
Explain the third normal form(3nf)?
explain the storage models of olap? : Sql server database administration
 Explain what is sql override for a source taLle in a mapping?
what are constraints? : Sql server database administration
How to generate create procedure script on an existing stored procedure?
What is stored in the mssqlsystemresource database? : sql server database administration
Can we install sql server 2016 on windows 7?
What command is used to rename the database?
How can you list all the table constraints in a database?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?