Post reply

read the sql error log file.

  • January 31, 2012 at 7:43 am

    #256013

    Hi, I manage 20 SQL 2008(not R2) servers in the company. I use 'xp_ReadErrorLog' on each server, save the result into a table. If the keyword 'error' or 'failed' appeared, SQL server will email me. (I run the sp as a job daily.)

    Since 'xp_ReadErrorLog' is an undocumented proc. I am wondering, is there any SQL 2008 build-in function that I can use for monitoring an individual server or on a central server to monitor a group of servers?

    Thanks for your help.

    _______________________________________________________________

  • January 31, 2012 at 8:07 am

    #1440671

    Just about all errors written to the error log can be emailed using the SQL Agent alerts.

    Alternatively, I'd look at using the Service broker and event notifications.

    I use combination of the two to cover most eventualities.

  • January 31, 2012 at 8:08 am

    #1440672

    I wrote an article on this. It can be tweaked to your choice (in terms of how frequent you want to get alerts).

    http://www.mssqltips.com/sqlservertip/2307/automate-monitoring-sql-server-error-logs-with-email-alerts/[/url]

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • January 31, 2012 at 8:12 am

    #1440677

    thank you all for helping me.

    this is the answer I needed.

    _______________________________________________________________

  • January 31, 2012 at 8:14 am

    #1440679

    Bru Medishetty (1/31/2012)

    I wrote an article on this. It can be tweaked to your choice (in terms of how frequent you want to get alerts).

    http://www.mssqltips.com/sqlservertip/2307/automate-monitoring-sql-server-error-logs-with-email-alerts/[/url]

    Personally, I prefer to be notified straight away in the event of an error.

Viewing 5 posts - 1 through 4 (of 4 total)

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