When using MS SQL Server, the following initial database configuration is recommended. However, On this page we state the minimum requirements for a SQL Server installation to support PhixFlow, and present a suggested installation.
The suggested installation incorporates the minimum requirements for SQL Server. It is suitable as an initial configuration for many instances of PhixFlow, but note that some of the options below may need to change over time as the work carried out by PhixFlow increases.
...
The following configuration is suggested as a guide. It incorporates the minimum requirements for SQL Server databases above.
The provision of database files fits in with the scheme presented in MS SQL Server planning for disk partitions on the database server.
...
Option | Setting |
SQL Server Edition | Standard or Enterprise |
Version | |
Collation Character set | Latin1_General_CI_AS |
Max Server Memory | Do not set a fixed maximum memory; see MS SQL Server planning |
Server Authentication | SQL Server and Windows Authentication Mode |
...
Name | Default | Autogrow All Files |
PhixFlow database | ||
PRIMARY | Yes | No |
Temp database | ||
PRIMARY | Yes | Yes |
Database Files
Logical Name | File Type | Filegroup | (Initial) size | Autogrowth/ Maxsize | Path (see MS SQL Server planning ) | Filename |
PhixFlow database | ||||||
phixflow | ROWS Data | PRIMARY | 10,000 MB | By 1000MB, Unlimited | On Disk 1 - data files | phixflow.mdf |
phixflow_log | LOG | - | 1000 MB | By 64 MB, Unlimited | Disk 2 - transaction logs | phixflow_log.ldf |
Temp database | ||||||
temp | ROWS Data | PRIMARY | 1000 MB | By 64 MB, Unlimited | On Disk 3 - temp DB | tempdb.mdf |
temp_log | LOG | - | 100 MB | By 64 MB, Unlimited | Disk 2 - transaction logs | tempdb.ldf |