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.