Chapter 16. Advanced Monitoring and Management Tools

In this chapter, you will learn how to:

  • Monitor Analysis Services using Windows Reliability And Performance Monitor.

  • Monitor Analysis Services using SQL Server Profiler.

  • Retrieve Analysis Services metadata and performance information using Dynamic Management Views.

In Chapter 13, and in Chapter 14, you learned how to take advantage of features that enable you to create large Analysis Services databases that provide fast query response. In Chapter 15, you learned how to deploy design changes to the Analysis Services server, how to back up and restore Analysis Services databases, and how to migrate Analysis Services databases from one server to another. In these three chapters, you have gained the ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step 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.