Building a complete monitoring solution
In this chapter, we saw a set of tools and techniques that we can use to monitor an Analysis Services instance. We already mentioned that it is a good idea to save trace and performance counter information in logfiles or SQL Server tables, so we can perform more detailed analysis on them. The logical next step would be to build a complete monitoring solution that could provide reports, statistics, and detailed information on all aspects of performance and usage, and that would be always running in the background, collecting data.
We could use all of this data as a source for a "performance and usage data mart", and use our favorite tools such as Reporting Services and Analysis Services to build a BI solution ...
Get Expert Cube Development with SSAS Multidimensional Models now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
