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