When does a large trx-log can affect performance ?

  • Hi,

    In witch situations having a large trx-log size can affect performance ? Replication ???

    Note : I am NOT talking about the performance degradation when the trx-log is gowing.

    Thank you

    calico (MCP MCTS)

  • calico-604598 (3/2/2010)


    Hi,

    In witch situations having a large trx-log size can affect performance ? Replication ???

    Note : I am NOT talking about the performance degradation when the trx-log is gowing.

    Thank you

    calico (MCP MCTS)

    Large transaction logs can affect performance when there are too many VLF's (see article by Kimberly Tripp in my sig).

    You could also run into problems with replication and log-shipping.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thank you Cirque du Soleil 😉

    performance of 'backup log' can be affected when there are too many VLF's

    Does performance of an 'application' can also be affected when there are too many VLF's ?

    NOTE : suppose that all the recomandations of Kimberly T. are fallowed

    thank you

    calico

  • Yes. Applications can also suffer from too many VLF's.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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