Analysis Services Performance

With the release of SQL Server Analysis Services 2016, Tabular models have the ability to process multiple partitions in parallel.

SQL Server 2017 Analysis Services Tabular new feature encoding hints for columns.

In SQL Server 2016 we have the option to start an Extended Events session using SQL Server Management Studio. In this tip we show how to use this solution to find the query plan for a DAX query, just like we can for T-SQL statements.

Partitioning data is a standard SQL Server administration practice. Partitions enable independent administration of different slices of data. When a SQL Server Analysis Services (SSAS) tabular data model is developed and processed, data is read from the s

Learn how to improve SQL Server Analysis Services MDX query performance with custom aggregations built in this tip.

What are the differences in MDX query response times among the different Analysis Services storage modes? SQL Server offers three cube types MOLAP, HOLAP and ROLAP. In this tip we will look at response times for each of the different cube types.

How much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to lear

Sometimes SQL Server Analysis Services query response time is too slow and we want to improve the performance. How can we do so? What options are available to improve SQL Server Analysis Services performance? In this tip we will improve the performance

Sometimes the SQL Server Analysis Services database query performance is slow and we need to improve performance. As a first step, I am assuming you have already created a partition to improve performance. In this tip I will demonstrate how to improve the

There are several aspects that can hurt performance of your Analysis Services cubes. Some problems could be on the source system, some could be because of poor design of your cube and MDX queries and some could be related to network issues. In this tip se

A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numer

In this tip series we have been discussing various techniques that can be used to optimize your SQL Server Analysis Services (SSAS) environment. In this segment we look at best practices for performance optimization for your cube design and development.

In the first part of this series we looked at processing performance, query performance and hardware resources for your SSAS enviornment. In this tip, I am going to share best practices and performance optimization techniques for source system design and

There are several aspects that can take a toll on performance for your Analysis Services cubes. Some problems could be related to the source systems, some could be because of poor design of your cube and MDX queries and some could be related to network is