...
Option | Setting |
SQL Server Edition | Standard or Enterprise |
Version | |
Collation Character set | Latin1_General_CI_AS The database that PhixFlow runs against must be created with the collation set to this character set (see Install the PhixFlow Database Schema), otherwise the performance of PhixFlow can be severely impacted. However, PhixFlow uses TEMP tables for efficient processing of ‘is in’ filter clauses with large numbers of parameters, and this uses the collation setting of the server itself. Therefore, it is strongly recommended that the server is set to use this collation. |
...
The provision of database files fits in with the scheme presented in MS SQL Server planning https://phixflow.atlassian.net/wiki/pages/createpage.action?spaceKey=HELPTRUNKR&title=MS%20SQL%20Server%20Planning 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 https://phixflow.atlassian.net/wiki/pages/createpage.action?spaceKey=HELPTRUNKR&title=MS%20SQL%20Server%20Planning ) | 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 |