The Mimer SQL database server process supports a number of separate request threads and background threads, running simultaneously under the operating system.
Number of Request Threads
The amount of concurrency the database server can support is dependent on the number of available request threads. If there are more concurrent requests than threads, the database server will start scheduling requests to improve response times. Increasing the number of request threads in a situation like this may improve performance.
The number of request threads in a database server is defined at system start-up. A change to the number of request threads requires that the system be stopped and re-started.
The maximum number of concurrent request threads is limited by the size of the bufferpool.
Number of Background Threads
The background threads in a Mimer SQL database server perform tasks such as:
Refer to the details on "Transaction count" and "Pending background thread requests" in the "Background threads" section of the Performance report, see The Performance Report for information relevant to fine tuning the number of background threads.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40