Post reply

Log file (when it grow)

  • November 5, 2015 at 7:25 am

    #302153

    Hi,

    How can I see how many times and when the log file of a database as grow (it is in auto grow mode)?

    Thank you

  • November 5, 2015 at 7:41 am

    #1837976

    Unless you have some form of monitoring to log when it happened, you could have a go at looking in the default trace, but note the default trace only keeps so much information so a very busy server could purge the default trace rather quickly.

    Other than that, write a routine to purge copy off the default trace files to a central area for processing, something like this https://www.simple-talk.com/sql/database-administration/collecting-the-information-in-the-default-trace/ or write a script to log when a growth event happens.

  • November 5, 2015 at 7:47 am

    #1837979

    You can also just right click on the DB in question in SSMS and select reports -> Disk Usage. If you have any Autogrow or even (yikes) Authoshrink events they should be listed there.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

  • November 5, 2015 at 7:53 am

    #1837981

    Think that still reads the default trace

  • November 5, 2015 at 8:35 am

    #1837993

    thanks

  • November 5, 2015 at 8:35 am

    #1837994

    How can I add figures like you just did?

  • November 5, 2015 at 8:47 am

    #1838001

    Use the IFCode IMG and past a URL to an image inbetween the [ I M G ] and [ / I M G ] tags (remove spaces from the tags) also the list of IFCodes is on the left hand side of the text box.

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

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