@SSCrazy, just confirmed, we don't have autoclose or autoshrink on, thanks for your feedback

Hi Jeff, I assume you are referring to a connection leak on the application side, correct? Which causes uncontrollable number of connections and I assume at some point it...

We ended up fixing the problem by rebooting our database server and applications servers that connect to it. Still unclear what caused the problem, if someone has any info...

Thanks everyone!

Thank you Gail, does that apply to all versions of SQL, we run Standard, does that make a difference as far as possible locks?

I'll take your advice and look closer...