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
Can we install sql server 2016 on windows 7?
What is @@error in sql?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Write an sql query for deleting duplicate rows?
What information is maintained within the msdb database?
What part does database design plays a role in performance of an sql server-based application?
What is sub-query in sql server?
What are the different types of Indexes available in SQL Server?
Why we need sql server?
What is the difference between the application object and session object?
How to store and query spatial data?
What are the steps to follow to configure SQL*Net?
Do comments need to go in a special place in sql server 2005?
Can a table be moved to different filegroup?
What is page in sql server?