SAP HANA Forum
What are typical reasons when calling transaction ST04 / DBACOCKPIT takes a long time?
Kindly share your valuable views here.
Thanks in advance.
When calling transaction ST04 takes a long time, you can check at first if calling transaction DBACOCKPIT is much quicker. Although both transaction codes are quite similar, they have different entrance screens and only with ST04 comprehensive SAP HANA performance data is shown.
If transaction ST04 is slow while DBACOCKPIT is much quicker, it may suffer from a high amount of SAP HANA alerts. If it takes many seconds or even minutes to start ST04, you can check according to SAP Note 2147247 if the number of alerts in table STATISTICS_ALERTS_BASE is too high and perform a cleanup.
In general you can create a SQL trace for starting ST04 / DBACOCKPIT using transaction ST05. This will show you which database requests take longest, so that you can analyze them more in detail.
Sign up for STechies