Hello,

could you elaborate? The instance is hosted on VMware hypervisor. I talked to the guy on the phone and asked him some basics but all I was able to get from him was:

Max Server Memory option is set

There is only one instance on that VM

It happens during nightly ETL loads - about once per month or two

I will know more as I see the instance. I'm just asking where would you suggest me to look first.

First I thought about setting alert for 802 error to execute job which would dump information about running jobs and some DMVs.

What do you think?