Publishing space
To ensure that PhixFlow can publish data changes, its database must have enough space to hold a copy of the largest streamtable. For OracleSQL Server, this space is in the temporary table spacefile group.
Tuning
Tuning MS SQL Server for optimum performance is a potentially complex task. However, in general, because PhixFlow uses simple statements to perform its operations, you can rely in most cases on a few settings to make use of available resources on the database server.
Memory settings
Microsoft do not recommend setting a fixed maximum memory: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15
Indicative sizings for DB servers are given here: Server Specification. Therefore, the server sizings give a broad indication of the memory requirements for MS SQL Server, allowing for head room for the operating system and other processes that must also run on the server, but in most cases you should not need to make any changes to the database configuration.
Indicative sizings
Indicative sizings of disks required for an MS SQL Server installation are given here. For a large installation, please discuss with your PhixFlow implementation team or with PhixFlow support.
...