Usually the
sql profiler tool is used for analyzing queries written against
sql server databases, typically to find performance bottlenecks. This tool is used to trap
sql sent by
SSRS/Applications communicating with a
sql server database. One of things I wanted to try after having heard about it was to use the
SQL Server
profiler for Analysis Services cubes (
SSAS). I connected to the analysis server and created a new profile, choose the standard option. Then I checked show all events, in the events selection tab there is a category called query processing which probably houses all the important events that happen when a cube is processed. There are events which show the
MDX script being executed, Getting data from Aggregation,Cache , whether a
subcube is being queried, these based on the results i saw are probably important events which can be analysed.
When looking at the results generated from these events, it gives a better idea of what happens beneath the cube in terms of which dimensions are being queried. Based on the findings this aspect of
sql profiler adds an another useful aspect to the already
existing important features.
No comments:
Post a Comment