It's a third party app on SQL Server 2008R2. In Test, they are trying to run some reporting, and they have to use the SPs with many built in CLR functions. Running the script in SSMS on a system with no other activity, occasionally their sessions will just spin for hours. Normally the process takes 30 seconds. When it occurs, checking their session shows "Sleeping". No locks. Just dead process, but SSMS never returns. Due to the intermittent nature, I haven't been able to catch it in Extended Events and see what portion ran right before it went idle. My only thought here would be it's dropping off in a CLR package but not reporting back to SSMS. This is a theory. Anyone run into this?