Can somebody provide some suggestions on how to configure an email alert for SQL Server memory consumption using counters like Total Server Memory(KB),Working Set or the SQL DMV counters?
I would prefer if this alert can be configured from inside SQL Server as I have DB mail configured.Example:It would send me an email if the Total Server Memory(KB) reaches 2GB.
Any help is appreciated.