Aaron Bertrand has a lot of jobs:
In the first few days of my new role at Infios, we came across an interesting case of memory exhaustion. A whole slew of memory-related error messages would populate the errorlog, then some stack and memory dumps would appear, and then the SQL Server service would just shut itself down without warning. Some of the errors we observed (apologies, it’s a long list, but I want to make sure that any subset might land you here):
Click through to see if you have any of those issues and one possibility of what the cause might be, as well as how to deal with it.