Allowed configurations

note

To activate product-specific features, enter your product key into the MSSQL_PID environment variable. If you do not provide any input, then the SQL Server Developer edition will be installed.

Server configuration	Environment variable	PDS default value
`SQL Server edition or product key`	`MSSQL_PID`
`memory.memorylimitmb`	`MEMORY_MEMORYLIMITMB`
`Optimize for ad-hoc workloads`	`OPTIMIZE_FOR_AD_HOC_WORKLOADS`	`1`
`Cost threshold for parallelism`	`COST_THRESHOLD_FOR_PARALLELISM`	`50`
`Max degree of parallelism`	`MAX_DEGREE_OF_PARALLELISM`
`Max server memory`	`MAX_SERVER_MEMORY_MB`
`Recovery model`	`MODEL_DB_RECOVERY_MODEL`	`SIMPLE`
`model database data file autogrowth size`	`MODELDB_DATAFILE_AUTOGROWTH_SIZE`	`256MB`
`model database log file autogrowth size`	`MODELDB_LOGFILE_AUTOGROWTH_SIZE`	`256MB`
`temp database data file size`	`TEMPDB_DATAFILE_SIZE`	`256MB`
`temp database log file size`	`TEMPDB_LOGFILE_SIZE`	`512MB`
`temp database data file autogrowth size`	`TEMPDB_DATAFILE_AUTOGROWTH_SIZE`	`128MB`
`temp database log file autogrowth size`	`TEMPDB_LOGFILE_AUTOGROWTH_SIZE`	`256MB`