The DS_MAX_QUERIES configuration parameter specifies a maximum number of decision-support queries that can run at any one time. In other words, DS_MAX_QUERIES controls only queries whose PDQ priority is nonzero. Queries with a low PDQ priority consume proportionally fewer resources, so a larger number of those queries can run simultaneously. You can use the DS_MAX_QUERIES parameter to limit the performance impact of CPU-intensive queries.
The database server uses the value of DS_MAX_QUERIES with DS_TOTAL_MEMORY to calculate quantum units of memory to allocate to a query. For more information on how the database server allocates memory to queries, see DS_TOTAL_MEMORY.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]