INF: A missing exception handle can cause blocking and eventual application hang.

BEHAVIOR/SYMPTOMS: We recently had a customer come to us seeking help on a performance issue that he was experiencing. Understood, that there’s a web-application written in ASP.Net and was using SQL Server at the backend. During the peak usage hours, the application users were experiencing query below timeout errors and sometimes the application even seemed…


SQL Server Management studio issues

What will happen if the indispensible SSMS crashes or worse just hangs? A lot of fretting!! (For the not-so SQLCMD savvy)….!! I have enclosed here two scenarios and their corresponding  resolutions PROBLEM 1 When we start up SQL Server Management studio we get the following pop-up: “SQL server management studio has encountered a problem and…