Export (0) Print
Expand All

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.

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.

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft