Soft Limits

CData Virtuality comes with pre-configured soft limits for the number of concurrently active queries and concurrently running jobs. These limits are “sanity limits”, which ensure that server load stays within a reasonable range. Since “reasonable” can be different for each system, these limits can be reconfigured. The default values are 20 concurrently active queries and 15 concurrently running jobs. If the limits are breached, the system will write the corresponding messages in the server.log. However, to some users, the system may appear as having performance problems or hung because the queries and jobs will be queued on the server side and so take longer to execute compared to the normal execution time. 

Please see the documentation about concurrently active queries (max-active-plans) here: Threading Options. Please note that when increasing the value of max-active-plans, it is also necessary to increase the value of max-threads value accordingly. 

Documentation about concurrently running jobs (org.quartz.threadPool.threadCount) can be found here: Threading Options.

Please see the subpage for SQL examples on how to read and set these parameters.