Managing Metadata Server Performance

Configuring Concurrent Queries/Clients

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.

Top of Page