Ok I have the sp_WhoIsActive working now. What parameters should I use with it when the issue occurs? I am currently using this:

EXEC sp_WhoIsActive

@show_sleeping_spids...

Hi Lowell

Thank you for that info. I have downloaded the sp_whoisactive and being a non SQL guru I don't know a lot about stored procedures but when I drag...

Hi Jon

Thanks for your reply. No we are licensed for 15 connections and never exceed 7. The timeout for inactivity is set to 20 min and for a disconnected...

Hi Steve

Thanks for your reply. I am fairly certain that it is not an attack the only access to the remote desktop services is through a encrypted VPN connection....