Skip to Content

One of my colleagues asked me how he can check quickly the performance settings in a BI system. That just gave me the idea to write a little blog about performance relvant BI transactions, tables and tasks. I try to compress it on one page so that you can print it out easily and hang it on your wall.

 

1. Loading Performance Transactions
RSMO – Requestmonitor
RSRQ – Single Requestmnonitor if you have the request id or SID
RSPC – Processchain
RSPCM – Processchain monitor (allproces chains at a glance)
BWCCMS – BW Computer Center Management System
RSRV – Check system for any inconsistencies
DB02 – Database monitor
ST04 – SQL monitor

 

2. Reporting Performance Transactions
RSRT – Query debug and runtime monitor
RSTT- execute query, get traces
ST03 – Statistics

3. Important Tables:
RSDDSTAT_DM Statistics DAtaManager for Query execution
RSDDSTATWHM Warehouse management statistics
RSDDSTAT_OLAP OLAP statistics
RSADMIN  RSADMIN parameters

4. Mandatory tasks

Check Cube performance tab in RSA1 (indexes and statistics) – every day

Check ST22 for shortdumps and SM37 for failed jobs – every morning

Check  DB02 for table space and growth – every day

Check request monitor – every morning

Check process chains for errors – every day

Load and update technical content – every day

Run BI Technical Content queries or check BI Administrator Cockpit – every day

Ok, that’s it for now.

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Davide Cavallari
    The process chain monitor (RSPCM) is really cool, as well as the BWCCMS, which I defenitely need to further investigate, as it seems really promising!

    Cheers, Davide

    (0) 
    1. Juergen Noe Post author
      No,
      it shows all process chains that have been executed. The ones executed lately are on top, older ones at bottom. You can restrict time frame and so it may be that the process chain does not appear any longer.
      (0) 
  2. Witalij Rudnicki
    Is in it that RSPCM shows only process chains scheduled for daily/hourly execution and does not show those executed out of this cycle? I just do not remember exactly…

    Thanks,
    -Vitaliy

    (0) 
    1. Juergen Noe Post author
      No,
      it shows all process chains that have been executed. The ones executed lately are on top, older ones at bottom. You can restrict time frame and so it may be that the process chain does not appear any longer.

      Regards,
      Juergen

      (0) 
    2. John Skrabak
      In my 3.5 and 7.0 systems, the initial display lists the chains alphabetically.  I can sort and filter the display, but have not found a way to save a sorted layout, as I would like it sorted by day and time by default.  Have you found anything to save the layout.

      Using the two right most icons (Create + Delete) you can decide what chains actually appear in RSPCM.  I only have my high level metachains setup to appear in RSPCM.

      (0) 
  3. Jay Roble
    You can also find PC (Process Chain) Run details in the following (BI 7.0 steps):

    1. Tran: ST03N
    >Expert Mode(select)
    >BI Workload (expand)>Choose Time Selection >Analysis Views (expand, will only appear if there is data)
    >Load data (expand) >Process Chains (double click)

    Displays Summary:
    PC Name, LogID, # Runs, # SubChains, Ave SubChains, # Steps, Ave Steps, Total Time, Total runtime / executions.

    You can drill into see individual PC executions.

    2. BW Tools (ST13)
    – Tran ST13
    >BW-Tools >Process Chain Analysis >Process Chains
    OR
    – Program /SSA/BWT
    >Process Chain Analysis >Execute
    then: 
    >Enter PC technical name, wildcard, or blank
    >Enter a date range >Execute

    DISPLAYS
    PC Satus, step status, PC Tech Name, Log Name, # SubChaings, #steps, Day, Date, Time & Runtime.

    OPTIONS
    a. Drill into PC Hierarchy
    >Expand all to see processes and/or subchains
    >Displays: Status, start time, runtime, # recs sent, #recs insert, Data type & InfoProviders.

    b.Drill into PC Log

    (0) 
    1. Arun Varadarajan
      One more transaction we found useful was os07 to monitor CPU and Memory usage for the app servers – thereby helping the scheduling for the same and also monitoring the CPU and memory consumption of the processes.

      Arun

      (0) 

Leave a Reply