SQL Server Performance

Alerts Not working

Discussion in 'General DBA Questions' started by Raulie, May 4, 2004.

  1. Raulie New Member

    I just installed a new SQL Server. I created some alerts on this server, but they dont seem to fire. For instance I just created a log failed alert 18456, I then tested the alert by attempting to log in to the server with a bogus password and nothing happend, the alert reports that it has never occured. Has this happend to any one?
  2. Luis Martin Moderator

    Check Troubleshooting Alerts in BOL, may be help.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  3. gaurav_bindlish New Member

    How are you sending the alert? Net Send? Check if the messenger service is running on the machine.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  4. Raulie New Member

    I'm using send email, that is not the problem though. They dont even show up as fired (Last Occured).
  5. Raulie New Member

    Ok I dont mean to go in circles her, but I have not solved this issue. I already read a gang of docs relating to Alert trouble shooting. Agent and Event log Services are turned on, operators working correctly, events are logged in application and sql error logs, service pak updated sp3. If I change the Alert type to fire only on performance conditions "it works". It is when I change the event to a SQL event alert that it gives me the problems. The funny thing is that it is only on this server. Before I reinstall can anyone give me any other advice?
  6. gaurav_bindlish New Member

    Are you sure there are no trace falgs that need to be enabled for the SQL Server events to be visible?

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  7. Luis Martin Moderator

    How about reinstall sp3?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

  8. derrickleggett New Member

    When you go to performance monitor, do the SQL Server trace groups show?

    MeanOldDBA
    [email protected]

    When life gives you a lemon, fire the DBA.
  9. satya Moderator

    http://www.databasejournal.com/features/mssql/article.php/3081171-fyi.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  10. Raulie New Member

    Thanks everyone.

    Gaurav Which specific trace flags should I enable?
    Luis I installed SP3a.
    MeanOldDBA yes all the trace groups do show.
    Satya I dont think the link works is correct.

Share This Page