Discovering how your models are performing

Several open source tools are available to support monitoring and performance tuning in Analysis Services. When working with multidimensional models, many of the tools are many years old and may not have been updated recently. Multidimensional models are very mature and have experienced little change in the past few years. Tabular models have some key tools that can help you monitor and improve the performance of your models. While all the tools are not covered in this section, we will bring up some industry accepted tools in the topic list at the end of this chapter.

While those tools exist, you should be aware of out-of-the-box capabilities with SQL Server. This includes the maintenance views and even performance monitoring.

Using Dynamic Management Views

Dynamic Management Views or DMVs are available for both multidimensional and tabular models. While the entire list of DMVs is out of scope for this book, we will introduce you...