Use SQL Temp Table Data Page (-SQLTempPageSize) to define the size of the temporary table data page.

Operating system and syntax UNIX / Windows -SQLTempPageSize value
Use with Maximum value Minimum value Single-user default Multi-user default
SQL 8 1 8 8
value
Size in Kilobytes.

This is a performance-tuning parameter and is not ordinarily required.

Change this parameter only when the sort record size exceeds the current page size, causing sort failures. For example, when sorting large rows, increasing -SQLTempPageSize may resolve the issue. However, it is important to note that larger page sizes directly impact memory consumption and can significantly increase the overall memory footprint of temp table operations.

SQL Temp Table Data Page (-SQLTempPageSize) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.

Notes

  • The SQL Temp Table Data Page (-SQLTempPageSize) parameter is used only if the startup parameter -SQLTempMgr Legacy is used. In ordinary use, -SQLTempDisk is ignored and has no effect.
  • The value-SQLTempPageSize must be set to either 1 or 8. Progress recommends setting this parameter to 8.