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
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.