Microsoft® SQL Server™ 2005 Administrator's Companion

Managing Analysis Services

If you’re responsible for maintaining a cube once the development phase is complete, the remainder of this chapter should be of high interest to you. Now it’s time to switch to a new environment, SQL Server Management Studio, to review its features for managing Analysis Services servers, including server configuration and deployment options for moving Analysis Services databases between servers. We’ll also review your options for managing scalability with partitioning, storage modes, and aggregations. Then, we’ll take a look at the various processing methods available for keeping cubes as up-to-date as possible and at security for managing access to cube data. Finally, we’ll briefly examine the use of SQL Server Profiler ...