O'Reilly logo

Expert Cube Development with SSAS Multidimensional Models by Marco Russo, Alberto Ferrari, Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required