Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8067 Views
- HCL, I also Faced
- E-Mail Answers
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
What is temporary table in sql server? Why we use temp table?
Different types of keys in SQL?
How to restore performance issues and how to check?
What are statistics?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Using the customer, and order table in northwind database, please write a query to produce xml?
What are the differences between web role and worker role?
What are types of subqueries?
What are the approximate numeric data types?
What are Spatial data types in SQL Server 2008
How can we get count of the number of records in a table?
explain different types of constraints? : Sql server database administration
Explain where clause?
Comment,Datatypes are unlimited
Is resultset an interface?
