cancel
Showing results for 
Search instead for 
Did you mean: 

Backup throughput for HANA

Former Member
0 Kudos

Hi Folks,

I did search in the system views section and also on the backup views.

But i didnt find a view which contains throughput of the backup did anyone get this info from a table.

I can see from the studio.

Message was edited by: Tom Flanagan

Accepted Solutions (1)

Accepted Solutions (1)

Bojan-lv-85
Advisor
Advisor
0 Kudos

Hello,

as already mentioned by my colleauge Ning Tong you can refer to the SQL command HANA_Backups_BackupRuns, particularly the following might be of interest for you:

Note 1999930:

"The column MB_PER_S in the output of this command provides information about the backup throughput. Values below 200 MB / s can indicate bottlenecks in the I/O area."

BR, Bojan

Former Member
0 Kudos

Thanks all. It did the trick.

Former Member
0 Kudos

Bojan,

Didnt find this field MB_PER_S

Were you referring to this script ?

HANA_Backups_BackupRuns.txt

Former Member
0 Kudos

Note 1999930:

"The column MB_PER_S in the output of this command provides information about the backup throughput. Values below 200 MB / s can indicate bottlenecks in the I/O area."

Bojan-lv-85
Advisor
Advisor
0 Kudos

Hello,

the column should be there in the latest SQL collection from note 1969700, File HANA_Backups_BackupRuns.txt

BR, Bojan

Answers (1)

Answers (1)

former_member182967
Active Contributor
0 Kudos

Hello guy,

I also don't find a view directly reflecting the throughput, but you can find the SQL script HANA_Backups_BackupRuns (from subquery of some table and not directly) attached by note 1969700 - SQL statement collection for SAP HANA.

Regards,

Ning