Calculating the Transaction Log Growth Rate

Use sp_logging_rate to calculate the transaction log growth rate for a specified time period.

sp_logging_rate displays the minumum, maximum, and average rate of transaction log growth, in gigabytes per hour, for the period of time you run the system procedure, providing the result as an averaged sum of the calculations, or as iterative results.

This example displays a summary the log growth for the transaction log over a 24-hour period, calculating the growth in one-hour intervals:

sp_logging_rate 'sum', '1,00:00:00', '01:00:00'
=========================
Total Summary Information
=========================
Transaction Log Growth Rate      Min GB/h        Max GB/h        Avg GB/h
---------------------------   --------------  --------------  --------------
                                  0.000000        1.970084        1.566053