Post reply

Need to fire an Memory Insufficient alert using DBmail

  • August 23, 2010 at 6:57 am

    #387635

    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

  • August 23, 2010 at 9:30 am

    #1210532

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply