Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
uladzislau_pralat
Contributor
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 (which is in line with BW/4HANA statistics approach). My BW table monitor program is helpful in many ways:

  • 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:

 

 

 
4 Comments
Labels in this area