Keeping BW system size under control is important for system performance and stability. There are many ways you can monitor table sizes. Some BW developers approach it from HANA native side, but I prefer from application side using CDS views (with is in line with BW/4HANA statistics approach). My BW table monitor program is helpful in many ways:
BW table monitor program is developed for BW on HANA and allows to monitor following tables:
By default, data is sorted by table size descending allowing to focus on largest tables first, but you can filter and sort data any way you like.
ABAP program code and CDS view code can be downloaded from Github:
Okumaya devam et...
- Monitor table sizes (find candidates for clean up and partitioning)
- Overview data target types (find candidates for HANA optimization and BW/4HANA conversion)
- Overview of PSAs (find candidates for housekeeping and ODP BW/4HANA conversion)
BW table monitor program is developed for BW on HANA and allows to monitor following tables:
- HANA Optimized Cube F-Table
- Standad Cube F-table
- Standad Cube E-table
- Classic DSO Active Table
- Classic DSO Change Log Table
- Classic DSO Inbound Queue
- Advanced DSO Inbound Table
- Advanced DSO Active Data Table
- Advanced DSO Change Log
- 3.x DataSource PSA
- 7.x DataSource PSA
By default, data is sorted by table size descending allowing to focus on largest tables first, but you can filter and sort data any way you like.
ABAP program code and CDS view code can be downloaded from Github:
- z_rsbasidoc.cds
- z_rsdodso.cds
- z_rsdsts.cds
- z_rstsods.cds
- z_bw_table_1.cds
- z_bw_table_2.cds
- zbw_table_monitor.abap
Okumaya devam et...