Data retention period in SAP PO Performance Monitor

SAP Performance Monitor allows you to analyze workload of your PO instance as per provided time intervals. Data used by Performance Monitor is stored in database therefore it’s invulnerable to loses during restarts.  It may be, however, insufficient to make a proper analysis with the default retained time intervals.

Default SAP settings

By default SAP PO performance monitor stores data for the following periods of time:

  • Last 7 days aggregated by 1day
  • Last 1 day aggregated by 1h
  • Last 1h aggregated by 15 min

Changing default settings

Since SAP PI 7.31 SAP delivered an enhancement to customize retention for performance monitor data. This option is available in SAP PI 7.4 and SAP PO 7.5 as well. To change default setting (DAILY=7, HOURLY=24, MINUTE=4) SAP provides a servlet accessible under the following URL.

URL:

http://<host>:<port>/mdt/performancedataqueryservlet?PeriodConfig=[<type>=<count>[,<type>=<count>]…]

Supported input parameters are:

<type>:

  • MINUTE – the 15-minute interval
  • HOURLY – the 1-hour interval
  • DAILY – the 1-day interval

<count>:

  • Any number greater than zero.

Other invalid inputs are ignored.

Examples

  1. Increase daily intervals to 14.  This way system will store data for last 14 days aggregated by 1 day (24-hour period).
    http://<host>:<port>/mdt/performancedataqueryservlet?PeriodConfig=DAILY=14
  2. Increase hourly intervals to 48. This way system will store data for last 48 hours aggregated by 1 hour.
    http://<host>:<port>/mdt/performancedataqueryservlet?PeriodConfig=HOURLY=48
  3. Increase minute intervals to 8. This way system will store data for last 2 hours aggregated by 15-minute periods.
    http://<host>:<port>/mdt/performancedataqueryservlet?PeriodConfig=MINUTE=8
  4. Set all 3 settings in points 1-3 at the same time.
    http://<host>:<port>/mdt/performancedataqueryservlet?PeriodConfig=DAILY=14,HOURLY=48,MINUTE=8

Attention

Since SAP PO Performance Monitor stores data in the database please note, that that changing default settings may cause respective table to grow. Table size can be estimated with the following formula:

Rows = Number of Server Nodes * PI Scenarios * (daily + hourly + minute)

Related content

Note 2006366 – Performance Monitor: change number of retained time intervals

Note 2099175 – Performance Monitor: change number of retained time intervals doesn’t work

 

About maciejbialek

Hello! I'm passionate, certified ABAP developer and SAP Consultant with many years of hands-on experience gained across several projects in Telco and Energy & Utilities industries. I've worked as Integration Architect, PI and ABAP Developer as well as BPC (NW) Consultant for local and international clients.

Leave a Reply