The number of
processors that are available to the metadata server determines the
number of concurrent queries that can run on the server.
If you expect a small
volume of concurrent clients, you can probably use a single-processor
machine. If you are expecting 1,000 concurrent clients, you will want
an eight-processor machine.
By default, the number
of queries (threads) that can be processed concurrently is set as
follows:
-
If the host machine has one processor,
then the maximum number of active threads is set to 2.
-
If the host machine has two or
more processors, then the maximum number of active threads is set
to the number of processors.
You can allow a different maximum number of active
threads by specifying a value for the server's MAXACTIVETHREADS
option. You can also configure the number of threads that are available
in the server's thread pool, or you can change the configuration
so that only a portion of the host machine's processors are dedicated
to metadata server processing. For details, see
Configuring the Number of Threads Used by the Metadata Server.