viernes, 22 de junio de 2012 20:17
I've got a SSAS 2012 tabular model deployed on an Azure VM roles that has about 4 GB of memory. Unfortunately, performance is poor and memory is maxed out when trying to execute several queries at one time - usually from MS Excel using the Refresh All option on a workbook with several pivot tables connected to the backend tabular model.
Besides the ability to scale up to a bigger VM, can anybody point me to scalability and high-availability options for an SSAS 2012 Tabular Model? Now that we can use the new Azure VMs more effectively, I'd love to find a way to create more redundancy and scalability than simply scaling up a single server.
Alternatively, is there some sort of option or configuration to make Excel and SSAS process multiple queries from a single workbook using a more serialized approach instead of thrown 10 different queries at the server all in parallel?
Thanks in advance!
Todas las respuestas
lunes, 25 de junio de 2012 5:44Moderador
Parallel processing is supported for different tables, but not for different partitions within a table. For more information, please refer to the following articles:
Processing tabular models 101: http://blogs.msdn.com/b/cathyk/archive/2011/09/26/processing-tabular-models-101.aspx
No parallel processing of partitions in tabular model: https://connect.microsoft.com/SQLServer/feedback/details/684254/no-parallel-processing-of-partitions-in-tabular-model#details
In addition, I would like to share some articles to you about Analysis Services performance tuning, please see:
Analysis Services Query Performance Top 10 Best Practices: http://sqlcat.com/sqlcat/b/top10lists/archive/2007/09/13/analysis-services-query-performance-top-10-best-practices.aspx
SSAS-Best Practices and Performance Optimization: http://www.mssqltips.com/sqlservertip/2565/ssas--best-practices-and-performance-optimization--part-1-of-4/
SQL Server 2008 White Paper: Analysis Services Performance Guide: http://www.microsoft.com/en-us/download/details.aspx?id=17303
TechNet Community Support
- Marcado como respuesta Elvis LongMicrosoft Contingent Staff, Moderator domingo, 01 de julio de 2012 6:50