Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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.

9 Comments