Verifique a performance das sessões de Backups no TSM
0
9:03:00 AM | , 

Execute:


SELECT client_name,session_id, current_timestamp-start_time - 
AS ElapTime, commmethod, state, CAST(bytes_sent/1024/1024 AS DEC(8,1)) - 
AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,1)) 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,1)) 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,1)) AS "Rcvd_MB/s" -
  FROM sessions WHERE session_type='Node'

CLIENT_NAME: ATHENA3_SQL2005A
SESSION_ID: 22749
ELAPTIME: 65323.607000
COMMMETHOD: Tcp/Ip
STATE: RecvW
MB_Sent: 0.0
MB_Rcvd: 1195494.6
Sent_MB/s: 0.0
Rcvd_MB/s: 51978.0

CLIENT_NAME: ATHENA3_SQL2005A
SESSION_ID: 22750
ELAPTIME: 65318.607000
COMMMETHOD: Tcp/Ip
STATE: RecvW
MB_Sent: 0.0
MB_Rcvd: 1199778.9
Sent_MB/s: 0.0
Rcvd_MB/s: 66654.3

Comments

0 responses to "Verifique a performance das sessões de Backups no TSM"

Post a Comment