SQLPool Settings

There are two SQLPool parameters: SQLPool initial size and SQLPool maximum size. The initial size is not critical as the pool automatically grows up to the maximum size.

Three things may limit the maximum size:

1) The amount of paging file in the machine.

2) The amount of memory the database server may allocate (The current version of the operating system has a limit of 2 giga-bytes). This includes stacks, code, the bufferpool, the SQLPool, and various other internal data areas of the database server.

3) The maximum number of kilobytes specified in the dialog box.

See also: other memory parameters.









Copyright Mimer Information Technology AB, Box 1713, SE-751 47 UPPSALA, Sweden. All Rights Reserved.
Submit a comment or suggestion.