Need to fire an Memory Insufficient alert using DBmail

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Need to fire an Memory Insufficient alert...

Need to fire an Memory Insufficient alert using DBmail

Rate Topic

Display Mode

Topic Options

Author

Message

amitghosh83

Posted Monday, August 23, 2010 6:57 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 4:25 AM
Points: 31, Visits: 17

Hello,

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.

Thanks,
Amit

Post #973403

Adiga

Posted Monday, August 23, 2010 9:30 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 23, 2013 12:23 PM
Points: 1,618, Visits: 20,901

Navigate to SQL Server Agent --> Alerts. Right Click and select New Alert. In the new alert enter the Error Number and in response select "Notify Operators"

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #973545

« Prev Topic | Next Topic »

Permissions