Our system is having a sudden trust of certain applications that is causing the Server memory load. and in some cases few of the commands are erroring out with the error which is getting captured in the SQL logs:
701 : insufficent memory to execute this statement.
For this i need to configure a alert that will fire a mail when this memory issue is popping up. I already have the DBmail set up on this server.
Any pointers to this issue is required urgently.