Post reply

Shrinking Log file?

  • April 24, 2007 at 12:00 pm

    #72807

    Does shrinking of log file impact performance on the database server?

  • April 24, 2007 at 12:50 pm

    #702237

    Yes

  • April 24, 2007 at 4:29 pm

    #702281

    I know that shrinking data files hinder performance, but is the same applies to log files?

    Because one of the log file is having 14GB of which only 70MB is being used space. Can we shrink this to some extent?

  • April 24, 2007 at 5:41 pm

    #702285

    Yes, you can.  But if it needs to grow again due to database updates or maintenance procedures, you will take a performance hit.

  • April 25, 2007 at 6:57 am

    #702356

    Growing and shrinking database files will cause performance hits.  I think it's a good practice to set a size for your files that you minimize the need for growth (both by giving a file a big space and making the file growth increment set to more than 10% or what ever fits in your situation).  You can't do all this if you're under drive space limitations.

    Good day,

    Bulent

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

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