\u5728 SAP \u7cfb\u7d71\u88e1\uff0c\u300cTrace\uff08\u8ffd\u8e64\uff09\u300d\u4e3b\u8981\u662f\u7528\u4f86\uff1a<\/p>\n
\n\u8a18\u9304\u7cfb\u7d71\u57f7\u884c\u904e\u7a0b\u4e2d\u7684\u7d30\u7bc0\uff0c\u7528\u4f86\u9664\u932f\u3001\u6548\u80fd\u5206\u6790\u3001\u554f\u984c\u5b9a\u4f4d\u3002<\/strong><\/p>\n<\/blockquote>\n
\u6709\u9ede\u50cf\uff1a<\/p>\n
\n
- Windows \u7684 Event Log<\/li>\n
- SQL Server Profiler<\/li>\n
- Oracle Trace<\/li>\n
- Linux strace \/ logs<\/li>\n<\/ul>\n
\u4f46 SAP \u7684 Trace \u7a2e\u985e\u975e\u5e38\u591a\uff0c\u56e0\u70ba SAP \u672c\u8eab\u5206\u6210\uff1a<\/p>\n
\n
- ABAP<\/li>\n
- HANA DB<\/li>\n
- RFC<\/li>\n
- Gateway<\/li>\n
- ICM<\/li>\n
- Work Process<\/li>\n
- SQL<\/li>\n
- Authorization<\/li>\n
- Update<\/li>\n
- Enqueue<\/li>\n
- ST05 \/ ST12 \/ SAT \u7b49\u5de5\u5177<\/li>\n<\/ul>\n
\n\u5e38\u898b SAP Trace \u7528\u9014<\/h1>\n
1. \u67e5\u6548\u80fd\u554f\u984c<\/h2>\n
\u4f8b\u5982\uff1a<\/p>\n
\n
- \u70ba\u4f55\u67d0\u4ea4\u6613\u78bc\u5f88\u6162\uff1f<\/li>\n
- \u54ea\u500b SQL \u5f88\u6162\uff1f<\/li>\n
- \u662f\u5426 Full Table Scan\uff1f<\/li>\n
- RFC \u5361\u4f4f\uff1f<\/li>\n<\/ul>\n
\u5e38\u7528\uff1a<\/p>\n
\n
- ST05 SQL Trace<\/li>\n
- ST12<\/li>\n
- SAT<\/li>\n<\/ul>\n
\n2. \u67e5 ABAP \u7a0b\u5f0f\u554f\u984c<\/h2>\n
\u4f8b\u5982\uff1a<\/p>\n
\n
- \u54ea\u500b FUNCTION \u88ab\u547c\u53eb\uff1f<\/li>\n
- LOOP \u592a\u591a\uff1f<\/li>\n
- SELECT * \u592a\u91cd\uff1f<\/li>\n
- \u7a0b\u5f0f\u908f\u8f2f\u8dd1\u592a\u4e45\uff1f<\/li>\n<\/ul>\n
\u5e38\u7528\uff1a<\/p>\n
\n
- SAT Runtime Analysis<\/li>\n
- SE30<\/li>\n<\/ul>\n
\n3. \u67e5\u6b0a\u9650\u554f\u984c<\/h2>\n
\u4f8b\u5982\uff1a<\/p>\n
\n
- \u70ba\u4f55\u4f7f\u7528\u8005\u88ab\u62d2\u7d55\uff1f<\/li>\n
- \u7f3a\u54ea\u500b Authorization Object\uff1f<\/li>\n<\/ul>\n
\u5e38\u7528\uff1a<\/p>\n
\n
- SU53<\/li>\n
- ST01 Authorization Trace<\/li>\n<\/ul>\n
\n4. \u67e5 RFC \/ \u5916\u90e8\u9023\u7dda\u554f\u984c<\/h2>\n
\u4f8b\u5982\uff1a<\/p>\n
\n
- SAP \u8207\u5916\u90e8\u7cfb\u7d71\u9023\u4e0d\u4e0a<\/li>\n
- RFC timeout<\/li>\n
- IDoc \u5931\u6557<\/li>\n<\/ul>\n
\u5e38\u7528\uff1a<\/p>\n
\n
- SM59 Trace<\/li>\n
- dev_rfc trace<\/li>\n<\/ul>\n
\n5. \u67e5 HANA SQL \u554f\u984c<\/h2>\n
\u4f8b\u5982\uff1a<\/p>\n
\n
- \u54ea\u500b SQL \u5403 CPU\uff1f<\/li>\n
- \u54ea\u500b Query \u7206 Memory\uff1f<\/li>\n
- Column Store \u6162\uff1f<\/li>\n<\/ul>\n
\u5e38\u7528\uff1a<\/p>\n
\n
- HANA Expensive Statements<\/li>\n
- SQL Trace<\/li>\n
- PlanViz<\/li>\n<\/ul>\n
\n\u4f60\u5e38\u770b\u5230\u7684 Trace \u985e\u578b<\/h1>\n
ST05 \u2014 SQL Trace<\/h2>\n
\u6700\u7d93\u5178\u3002<\/p>\n
\u53ef\u4ee5\u770b\u5230\uff1a<\/p>\n
\n
- SQL \u8a9e\u53e5<\/li>\n
- \u57f7\u884c\u6642\u9593<\/li>\n
- \u4f7f\u7528\u7d22\u5f15<\/li>\n
- Table Scan<\/li>\n
- RFC<\/li>\n
- Buffer \u4f7f\u7528\u60c5\u6cc1<\/li>\n<\/ul>\n
SAP BASIS \/ ABAP \u5f88\u5e38\u7528\u3002<\/p>\n
\nST12<\/h2>\n
ST05 + ABAP Trace \u6574\u5408\u7248\u3002<\/p>\n
\u5f88\u5f37\u3002<\/p>\n
\u901a\u5e38\u6b63\u5f0f\u5206\u6790\u90fd\u7528\u9019\u500b\u3002<\/p>\n
\nSAT<\/h2>\n
ABAP Runtime Analysis\u3002<\/p>\n
\u5206\u6790\uff1a<\/p>\n
\n
- \u54ea\u500b method \u6700\u6162<\/li>\n
- \u54ea\u500b function \u82b1\u6700\u591a\u6642\u9593<\/li>\n
- internal table \u554f\u984c<\/li>\n<\/ul>\n
\nST01<\/h2>\n
System Trace\u3002<\/p>\n
\u53ef\u8ffd\uff1a<\/p>\n
\n
- Authorization<\/li>\n
- RFC<\/li>\n
- Kernel call<\/li>\n<\/ul>\n
\u4f46\u5f88\u5403\u8cc7\u6e90\u3002<\/p>\n
\nHANA Trace<\/h1>\n
\u5728 SAP HANA Studio<\/span><\/span> \u6216 HANA Cockpit \u88e1\u9762\u4e5f\u5f88\u591a\uff1a<\/p>\n
\n
- Indexserver trace<\/li>\n
- Nameserver trace<\/li>\n
- SQL trace<\/li>\n
- Performance trace<\/li>\n<\/ul>\n
trace file \u901a\u5e38\u5728\uff1a<\/p>\n
\n\n\n\n\n\n\n\n\n<\/div>\n<\/div>\n<\/div>\n\n\n\n\n\n\/usr\/sap\/<SID>\/HDB<instance>\/<host>\/trace\/<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\u5e38\u898b\uff1a<\/p>\n
\n\n\n\n\n\n\n\n\n<\/div>\n<\/div>\n<\/div>\n\n\n\n\n\nindexserver_alert_<SID>.trc\r\nindexserver_<host>.trc<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n\u70ba\u4f55\u4e0d\u8981\u9577\u6642\u9593\u958b Trace\uff1f<\/h1>\n
\u56e0\u70ba\uff1a<\/p>\n
\n
- \u5f88\u5403 CPU<\/li>\n
- \u5f88\u5403 IO<\/li>\n
- trace \u6a94\u6703\u7206\u5927<\/li>\n
- \u53ef\u80fd\u5f71\u97ff\u6b63\u5f0f\u7cfb\u7d71\u6548\u80fd<\/li>\n<\/ul>\n
\u6240\u4ee5\u901a\u5e38\uff1a<\/p>\n
\n
- \u958b trace<\/li>\n
- \u91cd\u73fe\u554f\u984c<\/li>\n
- \u95dc trace<\/li>\n
- \u5206\u6790 log<\/li>\n<\/ol>\n
\nBASIS \u5e38\u898b\u60c5\u5883<\/h1>\n
\u4f7f\u7528\u8005\u8aaa\uff1a<\/h2>\n
\u300cVA03 \u5f88\u6162\u300d<\/p>\n
BASIS \u53ef\u80fd\uff1a<\/p>\n
\n
- ST12 \u958b trace<\/li>\n
- \u8acb\u4f7f\u7528\u8005\u91cd\u8dd1<\/li>\n
- \u5206\u6790\uff1a\n
\n
- SQL<\/li>\n
- RFC<\/li>\n
- ABAP<\/li>\n
- Lock<\/li>\n
- Buffer<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
\n\u4f60\u73fe\u5728\u5b78 HANA\/BASIS \u7684\u8a71<\/h1>\n
\u4f60\u4e4b\u5f8c\u4e00\u5b9a\u6703\u78b0\uff1a<\/p>\n
\n
- ST05<\/li>\n
- ST12<\/li>\n
- SAT<\/li>\n
- SM50<\/li>\n
- dev_w0<\/li>\n
- indexserver trace<\/li>\n
- HDB info<\/li>\n
- expensive statement trace<\/li>\n<\/ul>\n
\u9019\u4e9b\u5e7e\u4e4e\u662f BASIS \u65e5\u5e38\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728 SAP \u7cfb\u7d71\u88e1\uff0c\u300cTrace\uff08\u8ffd\u8e64\uff09\u300d\u4e3b\u8981\u662f\u7528\u4f86\uff1a \u8a18\u9304\u7cfb\u7d71\u57f7\u884c\u904e\u7a0b\u4e2d\u7684\u7d30\u7bc0\uff0c\u7528\u4f86\u9664\u932f\u3001\u6548\u80fd\u5206\u6790\u3001\u554f\u984c\u5b9a\u4f4d […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-1942","post","type-post","status-publish","format-standard","hentry","category-dxq_erp"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1942"}],"version-history":[{"count":1,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1942\/revisions"}],"predecessor-version":[{"id":1943,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/1942\/revisions\/1943"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1942"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}