克米亚sap论坛,中国最好的sap论坛,sap系统,sap培训,kemiya,克米亚,sap账号,sap ides,sap mm,sap hana,sap fico,sap pp

 找回密码
 注册
查看: 126|回复: 3

ST04: DB Performance Analysis

[复制链接]
kmy 发表于 2018-3-4 17:11:20 | 显示全部楼层 |阅读模式
Transaction code ST04 is used to shows detail of the database behave & usage, both history and current time.
Data buffer cache size & quality must be above 95% [meaning less physical read from disk]
User/Recursive Call > 2 [Recursive call will get more over time]
Read/User Call < 30 [> 30 means expensive SQL statements]
Time/User Call < 15ms
Busy time & CPU time ratio 60:40 ratio. Higher ratio means tuning required
Sort sections. It should be less than 0.1% of total sorts.
Shared pool statistics. DD (data dictionary) cache quality should be more than 99%, similarly the SQL area get ratio.
Instance performance. Soft parse ratio max value is 1 which is not possible because at least once the SQL is hard parsed and then soft parsed in its next executions. But this must be as close as possible to 1 for a healthy system. Similarly there is another fact which is in-memory sort ratio; this is for a healthy system should have higher values. In fact the less the disk sorts the better.

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x
yuans173 发表于 2018-3-7 08:30:26 | 显示全部楼层
感謝分享,很有用
彼岸的温柔 发表于 2018-4-24 15:03:58 | 显示全部楼层
sap sd
︶ㄣBeyond 发表于 7 天前 | 显示全部楼层
SAP 微信群
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|克米亚sap论坛,sap账号,sap系统,sap ides,sap学习机,sap练习环境 ( 渝ICP备18002525号-5 )

GMT+8, 2018-6-22 11:16

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表