Microsoft SQL Server Analysis Services Consolidation Best Practices and Considerations
In this session, learn about solutions and best practices from the SQLCAT team for consolidating Analysis Services solutions. Learn about consolidating relational sources with Analysis Services, about utilizing processing and query servers, and about a custom load balancing solution. Learn how to configure your consolidated environment for achieving high-availability and performance, and monitoring and balancing resource utilization. We present performance and availability numbers based on the Microsoft Sales consolidated environment, and we demo the Analysis Services Load Balancing solution.