Skip to Content
0
Former Member
Aug 03, 2016 at 06:03 PM

New feature to monitor transaction log growth rate (error with sum option)

64 Views

Hi .

Trying to use

sp_logging_rate

Calculates the transaction log growth rate for the specified time period.

Syntax

sp_logging_rate {'full'|'sum', '[day,]hh:mm:ss'}[, interval='hh:mm:ss' | clear_option='y'|'n']

Full option working fine ... but have issue with sum option ..

1> sp_logging_rate 'full', '00:03:00' ------> Working fine

2> go

But sum option giving below error (to monitor transaction log growth rate for 24 hours Sample every 3 minute ...

1> sp_logging_rate 'sum', '1,00:00:00','00:03:00'

2> go

Msg 17209, Level 16, State 1:

Server 'SYABSE_LAB', Procedure 'sp_logging_rate', Line 93:

Illegal format: '1,00:00:00 '.

Usage: sp_logging_rate {'full'|'sum', '[day,]hh:mm:ss'}[, @interval='hh:mm:ss'][, @clear_option='y'|'n']

(return status = 1)

Version :

Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25318 SMP/P/RS6000/AIX 7.1/ase160sp02plx/2492/64-bit/FBO/Sun Nov 22 18:44:08 2015

Thanks

Ajay Pandey