locked
SQL-Server Errorlog RRS feed

  • Question

  • Is there a way to get Alerts for the following SQL Severitys in the SQLError Log:

    Severity 17-25.

    Is there something in the SQL MP or a way to monitor this by a own MP.

    Can you give me some informations about this, I cannot find something like this in the www.

    Also I need the SQL-Server Threads where do I find this?

     

    Thanks for your informations.

     


    Monday, May 30, 2011 4:35 PM

Answers

  • The SQL MP does a lot of monitoring. I would ask the dba's to check the MP documentation and rules for SQL. If they still think they should have additional monitoring i would go for a logfile monitor (assuming the log can be read and isn't exclusively locked), checking for the severity in the line (matches regular expression).

    If it are custom alerts I would advise to let them also log to the eventlog. Then you  can use a simple eventlog rule to capture specific events.

    Normally the errorlog detailed information is used for troubleshooting, not for monitoring.


    Regards,
    Marc Klaver
    http://jama00.wordpress.com/
    • Marked as answer by Nicholas Li Wednesday, June 15, 2011 7:11 AM
    Wednesday, June 8, 2011 5:16 AM

All replies

  • This articels i found,too. Thank you.

     

    But with this i do not reach the aim to Monitor the severity. Perhaps my mind go crazy.

    Any other idea?

    Monday, May 30, 2011 7:51 PM
  •  

    Hi,

     

    I think you can also try to create a script based monitor:

     

    Viewing the SQL Server Error Log

    http://msdn.microsoft.com/en-us/library/ms187885.aspx

     

    Reading a logfile with a 3 state monitor

    http://contoso.se/blog/?p=1187

    Please Note: Since the website is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

     

    Hope this helps.

     

    Thanks.


    Nicholas Li - MSFT
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Wednesday, June 1, 2011 7:44 AM
  • Are you sure the default MP is insufficient?

    And if it are custom alerts, I would log them in the application log as well, so you can easily pick them up with an alert rule or monitor.


    Regards,
    Marc Klaver
    http://jama00.wordpress.com/
    Monday, June 6, 2011 8:24 AM
  • Hi Marc,

     

    no Im not sure. But where in the MP the severity is monitored?

     

     

    Tuesday, June 7, 2011 6:25 PM
  • It just depends on what you want to accomplish. If you just want to know how your SQL/db/filegroups are performing, I think the SQL MP is very good.

    Why do you need the severity messages being monitored seperately?


    Regards,
    Marc Klaver
    http://jama00.wordpress.com/
    Tuesday, June 7, 2011 6:32 PM
  • Its a task from my SQL Collegues.

    They want to have severity Monitoring and Configration Checks!

    I dont know if this makes sense...but i have no arguemant against this

    Tuesday, June 7, 2011 6:35 PM
  • The SQL MP does a lot of monitoring. I would ask the dba's to check the MP documentation and rules for SQL. If they still think they should have additional monitoring i would go for a logfile monitor (assuming the log can be read and isn't exclusively locked), checking for the severity in the line (matches regular expression).

    If it are custom alerts I would advise to let them also log to the eventlog. Then you  can use a simple eventlog rule to capture specific events.

    Normally the errorlog detailed information is used for troubleshooting, not for monitoring.


    Regards,
    Marc Klaver
    http://jama00.wordpress.com/
    • Marked as answer by Nicholas Li Wednesday, June 15, 2011 7:11 AM
    Wednesday, June 8, 2011 5:16 AM