SQLPool Sizes
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. On 64-bit machines the limit is currently 16 GB.
Three things may limit the maximum size:
- The amount of paging file in the machine.
- The amount of memory the database server may allocate (For the 32-bit version of Mimer SQL 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.
- The maximum number of kilobytes specified in the dialog box.
See Also