ITPub博客

首页 > Linux操作系统 > Linux操作系统 > BW Statistics 栏位说明

BW Statistics 栏位说明

原创 Linux操作系统 作者:leniz 时间:2009-04-23 16:44:54 0 删除 编辑

1. Times that are saved:
QTIMEOLAPINIT
Time of the initialization of the query (for example, loading
query in OLAP, compiling if required)
QTIMEOLAP
Time that the OLAP processor required
QTIMEDB
Time the database + network required to select the transaction
data. The time is measured from when the SQL command is send to
the database, and it is stopped when the requested data reaches
the application server. This time therefore includes the
transport on the network and the selection on the database.
QTIMEVARDP
Time the user required to enter the variables
QTIMEUSER
Time the user required between the navigation steps
QTIMECLIENT
Time of data formatting in the frontend
The time measurment starts when the OLAP processor has
completed the data formatting. The data is then sent to the
frontend (EXCEL). The time is stopped when the frontend (BW
add-in in EXCEL) has inserted all data in the worksheets
(writing the contents and formatting cell, if required). The
time therefore includes the transport on the network with the
RFC connection and the output in the frontend.
TIMECHAVLREAD
Time required to read master data

TIMEAUTHCHECK
Runtime of the authorization check.
TIMEREST
Time that could not be assigned in more detail (should be equal
to 0; if this is not the case, something in the internal
processing of the OLAP processor occured differently than
expected.)
QRUNTIMECATEGORY
Time of a navigation step (QTIMEOLAPINIT + QTIMEOLAP + QTIMEDB
+ QTIMEEXCEL + QTIMECHAVLREAD) rounded to the next higher
scaling (1,10,100,1000 ... seconds). As of 1.2B, this is
rounded to 1,2,3, ... 10,20,30,...100,200,300,... seconds.
2. Data regarding the size of the query:
QDBSEL
Number of the records that had to be read on the database
QDBTRANS
Number of records that the database transferred to the server
QNUMCELLS
Number of cells that were transferred to the frontend
QNUMRANGES
Number of formattings that were transferred to the frontend
RECCHAVLREAD
Number of master data records to be read
3. In addition, the following is saved:
QAGGRUSED
Name of the aggregate used
QNACHLESEN
Indicator: Query reads during each navigation step
4. Administrative information
STATUID
Key of the table; link in view RSDDSTAT_V
QSESSION
All data for a call of the frontend (between start and end of
the frontend) is compounded with this unique GUID.
QNAVSTEP
The navigation steps of a QSESSION are numbered in ascending
order
QNUMOLAPREADS
Number of read operations OLAP processor for each navigation
step

HANDLE
In the frontend, each embedded query has a separate, sequential
number (handle)

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/554557/viewspace-591595/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-05-31

  • 博文量
    448
  • 访问量
    1102729