Share via

Thread Pool Properties

  • Article

Microsoft SQL Server 2005 Analysis Services (SSAS) 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.

Note   Modifying the thread pool properties might have performance implications. For more information, see the section "Optimizing CPU usage" in the SQL Server 2005 Analysis Services Performance Guide.

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.

See Also

Reference

Analysis Services Configuration Properties

Help and Information

Getting SQL Server 2005 Assistance