Last active
June 14, 2017 10:52
-
-
Save mr-stringer/dbb35f906477d26bc1843ef4397a8d58 to your computer and use it in GitHub Desktop.
A query to get some basic details about the performance of full data backups in HANA
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| SQ.START_TIME AS START_TIME_OF_LAST_BACKUP, | |
| ROUND(TO_REAL(SQ.SIZE_MiB),1) AS SIZE_OF_LAST_BACKUP_MB, | |
| SQ.SECONDS AS SECONDS_ELAPSED, | |
| ROUND(SQ.SIZE_MiB/SECONDS,1) AS MB_PER_SECOND | |
| FROM | |
| ( | |
| SELECT | |
| C.UTC_START_TIME AS START_TIME, | |
| SECONDS_BETWEEN(C.UTC_START_TIME,C.UTC_END_TIME) AS SECONDS, | |
| SUM(F.BACKUP_SIZE)/1024/1024 AS SIZE_MiB | |
| FROM | |
| M_BACKUP_CATALOG AS C | |
| INNER JOIN | |
| M_BACKUP_CATALOG_FILES AS F | |
| ON | |
| F.ENTRY_ID = C.ENTRY_ID | |
| WHERE | |
| ENTRY_TYPE_NAME = 'complete data backup' | |
| AND | |
| STATE_NAME = 'successful' | |
| GROUP BY | |
| C.UTC_START_TIME, C.UTC_END_TIME | |
| ORDER BY | |
| START_TIME DESC | |
| LIMIT 1 | |
| ) AS SQ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment