Calculates the transaction log growth rate for the specified time period.
sp_logging_rate {'full'|'sum', '[day,]hh:mm:ss'}[, interval='hh:mm:ss' | clear_option='y'|'n']
sp_logging_rate 'sum', '1,08:00:00', '00:10:00' ========================= Total Summary Information ========================= Transaction Log Growth Rate Min GB/h Max GB/h Avg GB/h --------------------------- -------------- -------------- -------------- 0.000000 2.870076 1.823028
sp_logging_rate 'full', '00:03:00' Date Time Transaction Log Growth Rate GB/h --------------------------- -------------------------------- Oct 22 2013 6:00:32:480AM 0.406779 Oct 22 2013 6:00:42:483AM 0.000000 Oct 22 2013 6:00:52:483AM 0.000000 Oct 22 2013 6:01:02:483AM 0.000000 Oct 22 2013 6:01:12:490AM 0.000000 Oct 22 2013 6:01:22:500AM 0.000000 Oct 22 2013 6:01:32:476AM 2.341870 Oct 22 2013 6:01:42:483AM 2.828132 Oct 22 2013 6:01:52:480AM 2.850305 Oct 22 2013 6:02:02:483AM 2.782750 Oct 22 2013 6:02:12:483AM 2.853574 Oct 22 2013 6:02:22:480AM 2.002917 Oct 22 2013 6:02:32:483AM 2.848995 Oct 22 2013 6:02:42:483AM 2.754143 Oct 22 2013 6:02:52:483AM 2.854949 Oct 22 2013 6:03:02:480AM 2.722928 Oct 22 2013 6:03:12:476AM 2.870076 Oct 22 2013 6:03:22:480AM 2.697094 ========================= Total Summary Information ========================= Transaction Log Growth Rate Min GB/h Max GB/h Avg GB/h --------------------------- -------------- -------------- -------------- 0.000000 2.870076 1.823028
You must have system administrator privileges to execute sp_logging_rate.