Wednesday, June 28, 2023

SSAS Query Performance Detail Report

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.


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