Post reply

SQL Agent Alert

  • February 28, 2005 at 10:22 am

    #166046

    Hello-

    I was reviewing my error logs and found that I had two occurrences of tempdb log being full. 

    The default alert for Full tempdb is configured to e-mail myself and others, but it failed to do so. 

    Looking at the properties, I can see that it is enabled.  Last Occurred states "Never Occurred" and the Count is 0. 

    I am not sure what else to look at to determine why it failed to raise the alert properly.

    Regards,

    Scott

  • February 28, 2005 at 4:00 pm

    #544514

    You said that the log was full, but the alert was for the DB being full

    Yelena

    Regards,Yelena Varsha

  • March 1, 2005 at 12:16 am

    #544536

    did you stop and restart sqlagent after you implemented the first alert ?

    You have to when you implement your first active alert.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • March 1, 2005 at 6:40 am

    #544588

    The alert wasn't recently enabled, it's been configured for months and has been restarted many times. 

    I have seen you post that message before and it is a good thing to keep in mind when adding a new alert.  But I don't think it explains what happened.

    Thanks,

    Scott

  • March 1, 2005 at 8:51 am

    #544626

    Quite possibly the alert did not fire because many things use tempdb. If tempdb or it's log is full seemingly innocuous code like sp_who, select statements and many other things will not work. Just musing here ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • March 1, 2005 at 9:08 am

    #544630

    Hadn't thought about that, but it makes sense.

  • March 2, 2005 at 12:00 am

    #544770

    did your temdb-file(s) autogrow ?

    If this autogrow takes more time and the query times-out, you also get the message db-full , but the grow completes later on.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • March 2, 2005 at 7:09 am

    #544861

    You are on to something.  It did grow -- a lot!

    Now I need to figure out why.

    Thanks,

    Scott

Viewing 8 posts - 1 through 7 (of 7 total)

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