Optimal configuration settings for high concurrency in SSAS

Summary

When multiple users access SQL Server Analysis Services concurrently, an expensive query that needs to scan large number of partitions can monopolize the system and block other users. To avoid this problem and achieve high concurrency, it is recommended to set CoordinatorQueryBalancingFactor to 1 and CoordinatorQueryBoostPriorityLevel to 0.

More Information

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated 
SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA)




Server not configured for optimal concurrent query throughput




The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to check the current value for CoordinatorQueryBalancingFactor and CoordinatorQueryBoostPriorityLevel in msmdsrv.ini. If you run the BPA tool and encounter a warning message "Server not configured for optimal concurrent query throughput", you should check the current CoordinatorQueryBalancingFactor and CoordinatorQueryBoostPriorityLevel value in msmdsrv.ini and set them accordingly as recommended by BPA.

The SQL Server 2008 R2 BPA supports both SQL Server 2008 and SQL Server 2008 R2.
SQL Server 2008
SQL Server 2008 R2






SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)
Server not configured for optimal concurrent query throughput
The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to check the current value for CoordinatorQueryBalancingFactor and CoordinatorQueryBoostPriorityLevel in msmdsrv.ini. If you run the BPA tool and encounter a warning message "Server not configured for optimal concurrent query throughput", you should check the current CoordinatorQueryBalancingFactor and CoordinatorQueryBoostPriorityLevel value in msmdsrv.ini and set them accordingly as recommended by BPA.SQL Server 2012

 




خصائص

رقم الموضوع: 2135031 - آخر مراجعة: 02‏/04‏/2012 - المراجعة: 1

تعليقات