Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG BW Table Monitor

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
988
Tepki puanı
6
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:

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


Okumaya devam et...
 
Üst