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.