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
|
