SQl script that shows speed of running backups

[hogmaster]

Hello all just want to share q quick way to determine if something is amiss in the running backups.


def script q_speed "select client_name, bytes_sent/(1024*1024)/(cast ((current_timestamp-start_time)seconds as integer)) as speed from sessions" desc="Shows the speed in mb/s of running backups"

[GregE]

Thanks for sharing the info!

To expand on that, try this...

SELECT client_name,session_id, current_timestamp-start_time AS ElapTime, commmethod, state, CAST(bytes_sent/1024/1024 AS DEC(8,2)) AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,2)) AS "MB_Rcvd", cast((cast(bytes_sent as dec(18,0))/cast((current_timestamp-start_time) seconds as decimal(18,0))) / 1024 / 1024 AS DEC (18,2)) AS "Sent_MB/s", cast((cast(bytes_received as dec(18,0))/cast((current_timestamp-start_time) seconds as decimal(18,0))) / 1024 / 1024 AS DEC(18,2)) AS "Rcvd_MB/s" FROM sessions order by client_name

I take no credit for it. I found it around here somewhere a while back.