Performance Tuning SQL Server Analysis Services
Play Performance Tuning SQL Server Analysis Services
With the explosion of data that we have seen over the last few years, many companies have deployed SQL Server Analysis Services (SSAS) cubes to allow faster access to large volumes of data. However as the data sets grow, the performance of the cube, from both a user query perspective, and processing time, slows significantly. In this session we will take a deep dive into the fundamental inner workings of SSAS and look at options for performance tuning. This is not for the faint hearted and experience with SSAS is highly recommended.