Database Reference
In-Depth Information
•
Query Cube Begin
(
70
)/
Query Cube End
(
71
): These have no related
subclass events. After a
Query
Begin
event has been raised, in some
scenarios, the MDX Script of a cube must be evaluated before query
evaluation proper can start; in these scenarios
Query
Cube
Begin
is raised
after the
Execute MDX Script
End
event and shows when query evaluation
actually starts.
•
Query Dimension
(
81
): This event is raised when queries retrieve
members from dimension hierarchies. These members may or may not
be in cache already; if they aren't, we would expect to see some I/O read
operations executed:
°
Cache data
(
1
)
°
Non-cache data
(
2
)
•
Query Subcube
(
11
): As we saw in
Chapter 8
,
Query Performance Tuning
, a
single MDX query might result in several different subcubes of data being
requested from the Storage Engine. A
Query
Subcube
event is raised for each
of these requests, and may be one of the following types:
°
Cache data
(
1
)
°
Non-cache data
(
2
)
°
Internal data
(
3
)
°
SQL data
(
4
)
•
Query Subcube Verbose
(
12
): This is functionally identical to
Query
Subcube
, but it adds more information about the multidimensional
space of the subcube that is queried:
°
Cache data
(
1
)
°
Non-cache data
(
2
)
°
Internal data
(
3
)
°
SQL data
(
4
)
•
Calculation Evaluation
(
110
)/
Calculation Evaluation Detailed
Information
(
111
): These provide information about internal operations
in the Formula Engine. Several subclass events are available:
°
InitEvalNode Start
(
1
)
°
InitEvalNode End
(
2
)
°
BuildEvalNode Start
(
3
)
Search WWH ::
Custom Search