...
The command given in Install the PhixFlow Database Schema will create a database, login and user with the suggested settings.
Filegroups
Name | Default | Autogrow All Files |
PhixFlow database | ||
PRIMARY | Yes | ANALYSIS_DATANo |
Temp database | ||
PRIMARY | Yes | Yes |
Database Files
Logical Name |
Setting
phixflow
File Type | Filegroup |
Initial Size: 2000 MB
Autogrowth: 10% Unrestricted (or as per management policy)
Path: (As per management policy)
phixflow_data_01
Type: Rows Data
Filegroup: ANALYSIS_DATA
Initial Size: 100,000 MB
Autogrowth: 10% Unrestricted (or as per management policy)
Path: (As per management policy)
phixflow_log
Type: Log
Initial Size: 1000 MB
Autogrowth: 10% Unrestricted (or as per management policy)
Path: (As per management policy)(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 |