Thread Pool Properties
Microsoft SQL Server Analysis Services supports the thread pool server properties listed in the following tables. To view or change these properties for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties.
Parsing Category
Short\ NumThreads
A signed 32-bit integer property that defines the number of threads that can be created for short commands.Short\ PriorityRatio
An advanced property that you should not change, except under the guidance of Microsoft support.Short\ Concurrency
An advanced property that you should not change, except under the guidance of Microsoft support.Long\ NumThreads
A signed 32-bit integer property that defines the number of threads that can be created for long commands.Long\ PriorityRatio
An advanced property that you should not change, except under the guidance of Microsoft support.Long\ Concurrency
An advanced property that you should not change, except under the guidance of Microsoft support.
Query Category
MinThreads
A signed 32-bit integer property that defines the minimum number of threads for queries.MaxThreads
A signed 32-bit integer property that defines the maximum number of threads.The default value for this property is 10.
PriorityRatio
An advanced property that you should not change, except under the guidance of Microsoft support.Concurrency
An advanced property that you should not change, except under the guidance of Microsoft support.
Process Category
MinThreads
An advanced property that you should not change, except under the guidance of Microsoft support.MaxThreads
An advanced property that you should not change, except under the guidance of Microsoft support.PriorityRatio
An advanced property that you should not change, except under the guidance of Microsoft support.Concurrency
An advanced property that you should not change, except under the guidance of Microsoft support.