Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8073 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 happens if null values are involved in arithmetic operations?
Difference between Inner vs outer joins?
What are types of subqueries?
what are different types of backups available in sql server? : Sql server database administration
What is the difference between inner join and equi join?
How to generate create procedure script on an existing stored procedure?
What languages bi uses to achieve the goal?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is a mutating table error and how can you get around it?
Explain hostprotectionattribute in sql server 2005?
What do you mean by data integrity?
How to update multiple rows with one update statement in ms sql server?
How to end a stored procedure properly in ms sql server?
What is sharding?
What is mean by candidate key?
