Recently, while working on a SQL Performance issue, I encountered a blocking scenario, causing the query timeout and application hang. I worked on this issue along with my colleague Suhas. We started with some vanilla testing and eventually were able to re-produce the issue.

Read my latest post on SQLServerFAQ to figure out how can the issue be re-produced and of-course be avoided :-)

About SQLServerFAQ

SQLServerFAQ blog contains a plethora of information spread across various aspects of troubleshooting commonly encountered issues with SQL server. The posts are contributed by SQL PSS (Product Support) Engineering community.