Thank you. Since the incident I have lowered the max memory threshold in SQL and so far it's been working better. I also upped the threshold cost for parallelism to increase the likelihood of available threads.