Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 7885 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
Difference between group by clause and having clause in SQL?
What are the disadvantages of primary key and foreign key in SQL?
What is report subscription?
Explain what is public role in sql server?
Explain how would you store your query in an SSRS report or a Database server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What are group functions in query statements in ms sql server?
How to create dbo table in sql server?
Do you know sql server 2008 introduces automatic auditing?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is plan freezing?
Can another user execute your local temporary stored procedures?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Explain syntax for dropping triggers?
What is the difference between for trigger and after trigger?
