Hello,
i want an evaluation of the speed of the ndmp backup.
For the data I have sent the following select statement:
'select FILESPACE_NAME, CAPACITY, PCT_UTIL, (CAPACITY *PCT_UTIL)/100 as BELEGT, BACKUP_START, BACKUP_END, (BACKUP_END -BACKUP_START) AS Dauer from FILESPACES where NODE_NAME='IN-SV-NAM01-01' order by BACKUP_START desc'
The result looks like this:
FILESPACE_NAME: /in-sv-nasvm01-mir/Versuch
CAPACITY: 7864320,00
PCT_UTIL: 58,53
BELEGT: 4602986,4960
BACKUP_START: 2020-10-25 06:32:53.000000
BACKUP_END: 2020-10-25 21:59:51.000000
DAUER: 152658,000000
FILESPACE_NAME: /in-sv-nasvm01-mir/cax
CAPACITY: 7130316,80
PCT_UTIL: 81,54
BELEGT: 5814060,3187
BACKUP_START: 2020-10-24 12:04:32.000000
BACKUP_END: 2020-10-25 06:31:19.000000
DAUER: 182647,000000
I would like to divide "BELEGT" by "DAUER" to get the throughput of MB/s But I already have the problem that "BACKUP_END -BACKUP_START" has a result which I cannot assign. There are no seconds, I have already calculated that. A backup can also take more than 24 hours, in which case this value is higher, but still out of proportion to the actual duration. What do I interpret wrong?
i want an evaluation of the speed of the ndmp backup.
For the data I have sent the following select statement:
'select FILESPACE_NAME, CAPACITY, PCT_UTIL, (CAPACITY *PCT_UTIL)/100 as BELEGT, BACKUP_START, BACKUP_END, (BACKUP_END -BACKUP_START) AS Dauer from FILESPACES where NODE_NAME='IN-SV-NAM01-01' order by BACKUP_START desc'
The result looks like this:
FILESPACE_NAME: /in-sv-nasvm01-mir/Versuch
CAPACITY: 7864320,00
PCT_UTIL: 58,53
BELEGT: 4602986,4960
BACKUP_START: 2020-10-25 06:32:53.000000
BACKUP_END: 2020-10-25 21:59:51.000000
DAUER: 152658,000000
FILESPACE_NAME: /in-sv-nasvm01-mir/cax
CAPACITY: 7130316,80
PCT_UTIL: 81,54
BELEGT: 5814060,3187
BACKUP_START: 2020-10-24 12:04:32.000000
BACKUP_END: 2020-10-25 06:31:19.000000
DAUER: 182647,000000
I would like to divide "BELEGT" by "DAUER" to get the throughput of MB/s But I already have the problem that "BACKUP_END -BACKUP_START" has a result which I cannot assign. There are no seconds, I have already calculated that. A backup can also take more than 24 hours, in which case this value is higher, but still out of proportion to the actual duration. What do I interpret wrong?
