SAP BW Query常见的性能问题 沧海

摘要:
)oContentofTableRSDDSTATQuestion:2.DoIhavetodosomethingtoenablesuchtools?Answer:oYes,youneedtoturnontheBWStatistics:RSA1,chooseTools-˃BWstatisticsforInfoCubes(ChooseOLAPandWHMforyourrelevantCubes)Question:3.Whatkindoftoolsareavailabletoanalyseaspecificqueryindetail?Answers:oTransactionRSRToTransactionRSRTRACEQuestion:4.DoIhaveaoverallqueryperformanceproblem?Answers:oUseST03N-˃BWSystemloadvaluestorecognizetheproblem.Usethenumbergivenintable'Reporting-InfoCubes:Shareoftotaltime(s)'tocheckifoneofthecolumns%OLAP,%DB,%FrontendshowsahighnumberinallInfoCubes.oYouneedtorunST03NinexpertmodetogetthesevaluesQuestion:5.WhatcanIdoifthedatabaseproportionishighforallqueries?Answers:Check:oIfthedatabasestatisticstrategyissetupproperlyforyourDBplatform(aboveallfortheBWspecifictables)oIfdatabaseparametersetupaccordswithSAPNotesandSAPServices(EarlyWatch)oIfBuffers,I/O,CPU,memoryonthedatabaseserverareexhausted?oIfCubecompressionisusedregularlyoIfDatabasepartitioningisused(notavailableonallDBplatforms)Question:6.WhatcanIdoiftheOLAPproportionishighforallqueries?Answers:Check:oIftheCPUsontheapplicationserverareexhaustedoIftheSAPR/3memorysetupisdoneproperly(useTXST02tofindbottlenecks)oIfthereadmodeofthequeriesisunfavourable(RSRREPDIR,RSDDSTAT,Customizingdefault)Question:7.WhatcanIdoiftheclientproportionishighforallqueries?Answer:oCheckwhethermostofyourclientsareconnectedviaaWANConnectionandtheamountofdatawhichistransferredisratherhigh.Question:8.WherecanIgetspecificruntimeinformationforonequery?Answers:oAgainyoucanuseST03N-˃BWSystemLoadoDependingonthetimeframeyouselect,yougethistoricaldataorcurrentdata.oTogettoaspecificqueryyouneedtodrilldownusingtheInfoCubenameoUseAggregationQuerytogetmoreruntimeinformationaboutasinglequery.UsetabAlldatatogettothedetails.(DB,OLAP,andFrontendtime,plusSelect/Transferredrecords,plusnumberofcellsandformats)Question:9.WhatkindofqueryperformanceproblemscanIrecognizeusingST03Nvaluesforaspecificquery?Answers:(UseDetailstogettheruntimesegments)oHighDatabaseRuntimeoHighOLAPRuntimeoHighFrontendRuntimeQuestion:10.WhatcanIdoifaqueryhasahighdatabaseruntime?

BW Query Performance

Question:
1. What kind of tools are available to monitor the overall Query Performance?

Answers:
o BW Statistics
o BW Workload Analysis in ST03N (Use Export Mode!)
o Content of Table RSDDSTAT

Question:
2. Do I have to do something to enable such tools?

Answer:
o Yes, you need to turn on the BW Statistics:
RSA1, choose Tools -> BW statistics for InfoCubes
(Choose OLAP and WHM for your relevant Cubes)

Question:
3. What kind of tools are available to analyse a specific query in detail?

Answers:
o Transaction RSRT
o Transaction RSRTRACE

Question:
4. Do I have a overall query performance problem?

Answers:
o Use ST03N -> BW System load values to recognize the problem. Use the
number given in table 'Reporting - InfoCubes:Share of total time (s)'
to check if one of the columns %OLAP, %DB, %Frontend shows a high
number in all InfoCubes.
o You need to run ST03N in expert mode to get these values

Question:
5. What can I do if the database proportion is high for all queries?

Answers:
Check:
o If the database statistic strategy is set up properly for your DB platform
(above all for the BW specific tables)
o If database parameter set up accords with SAP Notes and SAP Services (EarlyWatch)
o If Buffers, I/O, CPU, memory on the database server are exhausted?
o If Cube compression is used regularly
o If Database partitioning is used (not available on all DB platforms)

Question:
6. What can I do if the OLAP proportion is high for all queries?

Answers:
Check:
o If the CPUs on the application server are exhausted
o If the SAP R/3 memory set up is done properly (use TX ST02 to find
bottlenecks)
o If the read mode of the queries is unfavourable (RSRREPDIR, RSDDSTAT,
Customizing default)

Question:
7. What can I do if the client proportion is high for all queries?

Answer:
o Check whether most of your clients are connected via a WAN Connection and the amount
of data which is transferred is rather high.

Question:
8. Where can I get specific runtime information for one query?

Answers:
o Again you can use ST03N -> BW System Load
o Depending on the time frame you select, you get historical data or
current data.
o To get to a specific query you need to drill down using the InfoCube
name
o Use Aggregation Query to get more runtime information about a
single query. Use tab All data to get to the details.
(DB, OLAP, and Frontend time, plus Select/ Transferred records,
plus number of cells and formats)

Question:
9. What kind of query performance problems can I recognize using ST03N
values for a specific query?

Answers:
(Use Details to get the runtime segments)
o High Database Runtime
o High OLAP Runtime
o High Frontend Runtime

Question:
10. What can I do if a query has a high database runtime?

Answers:
o Check if an aggregate is suitable (use All data to get values
"selected records to transferred records", a high number here would
be an indicator for query performance improvement using an aggregate)
o Check if database statistics are update to data for the
Cube/Aggregate, use TX RSRV output (use database check for statistics
and indexes)
o Check if the read mode of the query is unfavourable - Recommended (H)

Question:
11. What can I do if a query has a high OLAP runtime?

Answers:
o Check if a high number of Cells transferred to the OLAP (use
"All data" to get value "No. of Cells")
o Use RSRT technical Information to check if any extra OLAP-processing
is necessary (Stock Query, Exception Aggregation, Calc. before
Aggregation, Virtual Char. Key Figures, Attributes in Calculated
Key Figs, Time-dependent Currency Translation)
together with a high number of records transferred.
o Check if a user exit Usage is involved in the OLAP runtime?
o Check if large hierarchies are used and the entry hierarchy level is
as deep as possible. This limits the levels of the
hierarchy that must be processed. Use SE16 on the inclusion
tables and use the List of Value feature on the column successor
and predecessor to see which entry level of the hierarchy is used.
- Check if a proper index on the inclusion table exist

Question:
12. What can I do if a query has a high frontend runtime?

Answers:
o Check if a very high number of cells and formattings are transferred
to the Frontend ( use "All data" to get value "No. of Cells") which
cause high network and frontend (processing) runtime.
o Check if frontend PC are within the recommendation (RAM, CPU Mhz)
o Check if the bandwidth for WAN connection is sufficient

免责声明:文章转载自《SAP BW Query常见的性能问题 沧海》仅用于学习参考。如对内容有疑问,请及时联系本站处理。

上篇Delphi编译选项解决Chrome浏览器不能访问https网站的问题下篇

宿迁高防,2C2G15M,22元/月;香港BGP,2C5G5M,25元/月 雨云优惠码:MjYwNzM=

相关文章

docker run hangs问题排查记录

1、故障描述   这两天遇到一个非常诡异的问题,现在将完整的故障描述如下: 1)最初是同事跟我反馈k8s集群中有个worker node状态变为NoReady,该node的kubelet的error日志中发现大量这种日志 E0603 01:50:51.455117 76268 remote_runtime.go:332] ExecSync 1f0e3a...

解决'androidx.arch.core:core-runtime' has different version for the compile (2.0.0) and runtime (2.0.1)

先说原因,我们引用的包版本不同产生了冲突,所以编译不通过。解决的办法是在引用的时候排除一个版本,只留一个版本。 解决过程: 先找出哪些库引用了相同的库,仅仅是版本不同。 gradle app:dependencies app换成你工程中的模块名,它会生成一个依赖列表,我们要做的是分析一下这个列表,比如我的引用就是: dependencies { i...

框架dubbox的简单使用

之前: RPC: Remote Produedure Call :一种通过网络从远程计算机程序上请求服务,而不需要了解底层网络技术的协议 SOA: Service-oriented architecture面向服务的体系结构(SOA)是一个组件模型,它将应用程序的不同功能单元(称为服务)通过这些服务之间定义良好的接口和契约联系起来。接口是采用中立的方式进行定...

ubuntu 18.04, 编译运行ORB_SLAM3, 遇到错误Pangolin X11: Unable to retrieve framebuffer options。

当前问题 遇到错误Pangolin X11: Unable to retrieve framebuffer options。操作系统是ubuntu 18.04,物理机,不是虚拟机. 按报错Pangolin X11: Unable to retrieve framebuffer options ,修改components/pango_windowing/sr...

uni-app 中如何打开外部应用

1  plus.runtime.openURL(this.url, function(res) { //this.url:scheme例如 'alipay://' console.log(res); }); 2 let _this = this; // 判断平台 if (plus.os.n...

《ArcGIS Runtime SDK for Android开发笔记》——离在线一体化技术:离线矢量数据下载

1、前言 1.1、环境准备: ArcGIS for Desktop 10.4.1(10.2.1以上版本即可) ArcGIS for Server 10.4.1 (10.2.1以上版本即可) PostgreSQL、Microsoft SQL Server、或 Oracle 设置企业级地理数据库。 1.2、发布具有同步能力的FeatureService服...