We have a .net application hosted in iis. We have a server where we have enabled iis and installed sql server 2014.
From past few days we are facing an issue where query just hangs up, kind of like a deadlock.
We are facing this issue on regular basis, last time when the query hanged while executing we opened sql server profiler and saw many query executing on suspended state.
Right Clicking and
Selecting Details nothing happens, same with
Trace Process in sql server profiler .
We even enabled
Sql Server Profiler to include
Deadlock Graph in
Locks but nothing showed when issue occured.
Attached zipper containing error images