BI Server very slow

[Former Member]

Hi All,

Currently the BI server is very slow. Accessing the tcodes itself takes long time. Can anybody tell me the tcodes to monitor the server utilisation. How to improve the performance of BI system.

Regards,

Anand

[Former Member · Accepted solution]

Poor performance could be caused by many things.

Os level, check cpu utilization and memory usage with st06. If you are cpu bound or paging excessively it will cause very poor response time.

Look at sm51/sm50 to check for free dialogs. Are you running several data loads with parallel processing that could be tying up all your dialogs.

DB

st04, db02, Check that you are running runstats, that you have good buffer hit ratiios. Backups are at off-peak times

db01 to check for lock waits/deadlocks

[Former Member · Accepted solution]

Patrick thanks for your reply. I was looking for ST06 tcode.

[Former Member]

Hi,

First check your DIA response time of the server. goto ST03N. Here you will get the avg response time,

you can get the top response time of the dia steps, DB times. check the buffer ratio.

Please read some BASIS monitoring guide.

With Regards,

CSK

[Former Member]

Hi,

Please check the following.

check DB02 for tablespace status and free space

check SM21 for system logs adn thing related to database.

check sm13 for updates status and then alsoc heck ST04 for DB performance

also check ST02 for paging.

also check the OS level parameters as well.

Thanks,

chaitanya

[franz_hiltscher]

Hi,

you can also use ST03N. Compare the current workload with statistical data to see what is differnt.

Are your db statistics up to date?

Kind Regards

Franz