Skip to main content

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

Was this page helpful?