Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to fire an Memory Insufficient alert using DBmail Expand / Collapse
Author
Message
Posted Monday, August 23, 2010 6:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Monday, August 23, 2010 9:30 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:14 AM
Points: 1,618, Visits: 20,979
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 »

Add to briefcase

Permissions Expand / Collapse