For the full blog, kindly follow :
http://www.sqlserverpath.org/2012/08/10/how-to-resolve-heavy-locks-and-deadlocks-14/
Categories: Database Administration, T-SQL Performance
Oops, you forgot something.
The words you entered did not match the given text. Please try again.
Oops!
Oops, you forgot something.