SQL stack dump

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tolcis - 08 Feb 2010 18:55 GMT

Hi,
We had a situation recently when stack dump was generated in the SQL
Server log for one of the sql jobs without affecting any users but
didn't know about it without manually looking at the error log
Is there a way to monitor a SQL Server for a Stack dump.
We need to get notified when the stack dump happened and it would be
nice to get a stack dump snapshot as well (but this part is optional).
I would appreciate any ideas.

T.

Reply to this Message

Jay - 09 Feb 2010 01:40 GMT

Did you get an error number?

I do not know, but I would try to capture the event in the SQL agent's
"alerts" section - which requires an error number.

> Hi,
> We had a situation recently when stack dump was generated in the SQL
[quoted text clipped - 6 lines]
>
> T.

Reply to this Message

Jay - 09 Feb 2010 01:58 GMT

> Did you get an error number?

Or a severity level?

> I do not know, but I would try to capture the event in the SQL agent's
> "alerts" section - which requires an error number.
[quoted text clipped - 9 lines]
>>
>> T.

Reply to this Message