Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 3 Answers
- 8054 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
How to get a list of columns in a view using the "sp_help" stored procedure?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is the sql profiler?
Write a query to find 5th highest amount paid from the customer table.
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Explain the dbcc pintable command when would you use it?
What is 1nf 2nf?
What are the operating modes in which database mirroring runs?
What happens when the SQL Azure database reaches Max Size?
How to create median function?
What is the difference between NOROW and LOCKROW?
What is the default order of an order by clause?
What is stretch database in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
What stored by the master? : sql server database administration
