Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
About the Author
About the Reviewers
More DBA Manageability Best Practices

Administrating multiple Analysis Services using Tools

Administering and managing Analysis Services includes managing all instances by maintaining optimal security, deployment, and data recovery that will process the data warehouse objects. The SQL Server tools can help the users and help the DBAs in automating tasks and monitoring activity within an Analysis Services instance. The service management tools can configure the server properties using SQL Server Management Studio and MMC snap-in makes it possible for users to configure Windows services. In this recipe, we will go through the important aspects and processes in the administration of multiple analysis services instances using the available tools.

Apart from sharing the same server hardware resources, every instance of SQL Server Analysis Services is completely independent, with independent executables, properties, security models, cubes, and so on.

How to do it...

The following are important points in administering and managing multiple...