The objective of this article is provide information on how to monitor Cube performance by logging their query logs and display costly queries.
Below is the layout for Cube wise Query performance detail report which shows all the queries which degrade the performance of SSAS Cube.
Layout
Business Rule
• This report will show the Query Performance Statistics for all the queries logged in the Cube(s) in an instance of SQL Server Analysis Services
• In this Report, we will show SSAS Cube wise query details, Cube, CPU time taken by the query and duration.
• This report helps the users to understand what are the queries that takes more time for their execution
• Based on this Report, User(s) can take necessary decisions to improve the performance
• System will show this report from the data comes from the SQL profilers
No comments:
Post a Comment