What is blocking and how would you troubleshoot it?
- 3 Answers
- 7316 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 the maximum size of a row in sql server?
What is snapshot report?
Can we call future method from trigger?
If the job running very slow what is the action you do
What are the authentication modes in sql server? How can it be changed?
What is a transact-sql statement?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
how to define testing of network layers? : Sql server database administration
Please differentiate between a local and a global temporary table?
What is bit data type?
How do you drop an index?
What is database mirroring?
What are the different ways you can create databases in sql server?
Explain different types of Normalization.
Can binary strings be used in arithmetical operations?
