Post reply

exact way to find transaction log growth rate

  • December 1, 2008 at 5:36 am

    #203639

    Hi all,

    how to find the transaction log growth rate approximately. I used disk usage of management studio, but the log flushes very quickly like in secs for 2 GB transaction log file size and couldn't find the rate even i tried with high GB log file size but there log quickly flushes, but i manage to take the rate within those secs but not confident in that values. Is there any other way to find out the transaction rate.

    thanks in advance.

  • December 1, 2008 at 5:55 am

    #905541

    You could try DBCC SQLPERF(LOGSPACE) for the percentage of the file used. You could also count the rows in fn_dblog(null, null), but that can get intensive and time consuming, especially on larger systems.

    What are you trying to find out with this?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 1, 2008 at 6:20 am

    #905556

    thanks for the reply, i will try with that. We are tuning and testing the server for replication , in that we also need to know the thershold log growth rate in which it gives minimum or no lag.

  • December 1, 2008 at 6:29 am

    #905563

    What you can do is just check the size of your log backups. That'll give you an easy way to get the average log volume.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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