Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    18

    Unanswered: 14 Gig Tx Log - Performance Hit?

    Hi

    My clients haven't backed up their database since the year dot. Just dialled in and found that their tx log is 14 gig.

    My question: will this cause performance problems - especially when it tries to increase the log file size?

  2. #2
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42

    Re: 14 Gig Tx Log - Performance Hit?

    You need this to be sorted out very soon.

    It will suffocate the performance never mind slow it down!

    Do you know how to shrink the tx log?
    Shadow to Light

  3. #3
    Join Date
    Jul 2003
    Posts
    18
    Yup - right down. And they've suddenly come up with a backup policy...

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check your other post for replies and suggestions.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    just do a checkpoint on the db. There is no performance impact because of the size of log. It'll just take longer during the recovery process when the service is restarted. However, your client may run out of disk space, at which point the db will become suspect.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •