Post reply

Log file monitoring

  • January 4, 2011 at 2:33 am

    #149634

    Hi experts,

    I plan to monitor log file growth on both SQL Server 2000 and 2005 instances for all the existing databases. I'd like a notification sent once the log file size exceeds 70% of the data file size. Can this be done?

    I suppose setting up a custom job that send notification (eg email) to me would be the only choice as SQL alerts cannot be configured that way? Is that correct? If so, how can I proceed with this?

    Thank you all. 😉

    __________________________
    Allzu viel ist ungesund...

  • January 4, 2011 at 3:18 am

    #1268831

    SQL Server "Alerts" can be configured to trigger when the Transaction Log is xx% full. As you mentioned, you have to write a custom script to meet the requirement.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 2 posts - 1 through 2 (of 2 total)

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