Hello,
I would like to calculate the data throughput of ndmp backups. I have the amount of data, the duration, but I don't know how to decompose the duration specification so I can calculate the data throughput (GB/hour).
The query so far is:
select FILESPACE_NAME, CAPACITY,BACKUP_START, BACKUP_END, (BACKUP_END-BACKUP_START) as DURATION from FILESPACES where (NODE_NAME='IN-SV-CL2-01' or NODE_NAME='IN-SV-CL2-02') order by BACKUP_START asc
One of the result is:
FILESPACE_NAME: /in-sv-cl2svm1-DR/Projekte
CAPACITY: 24641536.00
BACKUP_START: 2023-08-26 00:00:20.000000
BACKUP_END: 2023-08-27 00:53:55.000000
DURATION: 1005335.000000
The output of the duration has the following structure:
the last two numbers are the seconds, the two numbers before that are the minutes, the two numbers before that are the hours and the number before that are the days.
In the example, the ndmp backup lasted one day, zero hours, 53 minutes and 35 seconds.
Unfortunately, I have no idea how to modify a SELECT statement so that I then get the desired result. Maybe there is someone who can solve the problem for me. Thank you very much.
I would like to calculate the data throughput of ndmp backups. I have the amount of data, the duration, but I don't know how to decompose the duration specification so I can calculate the data throughput (GB/hour).
The query so far is:
select FILESPACE_NAME, CAPACITY,BACKUP_START, BACKUP_END, (BACKUP_END-BACKUP_START) as DURATION from FILESPACES where (NODE_NAME='IN-SV-CL2-01' or NODE_NAME='IN-SV-CL2-02') order by BACKUP_START asc
One of the result is:
FILESPACE_NAME: /in-sv-cl2svm1-DR/Projekte
CAPACITY: 24641536.00
BACKUP_START: 2023-08-26 00:00:20.000000
BACKUP_END: 2023-08-27 00:53:55.000000
DURATION: 1005335.000000
The output of the duration has the following structure:
the last two numbers are the seconds, the two numbers before that are the minutes, the two numbers before that are the hours and the number before that are the days.
In the example, the ndmp backup lasted one day, zero hours, 53 minutes and 35 seconds.
Unfortunately, I have no idea how to modify a SELECT statement so that I then get the desired result. Maybe there is someone who can solve the problem for me. Thank you very much.