Skip to main content
Version: 24.09.02

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.
  • Use the parameters specified in the Environment variable column as key-value pairs either during the template configuration or when deploying the data service.

Following are the configurable parameters for the SQL Server data service:

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

Availability groups

The SQL Server Always On availability groups (AG) integration into PDS offers substantial benefits for customers by significantly enhancing data availability capabilities. SQL Server AG provides automatic failover, ensuring high-availability and minimizing downtime for mission-critical applications. This integration supports seamless data replication and backup across multiple databases and servers. By leveraging SQL Server AG, PDS users can achieve a robust, scalable, database infrastructure, crucial for maintaining business continuity and optimizing performance.

Refer to the Microsoft documentation about Always On availability groups for more information.

note
  • During SQL Server deployment, no database will be created with AG capability. The Standard edition supports basic availability groups, which accommodate two replicas and one database. For more information about basic availability groups, see Basic Always On availability groups for a single database.
  • Implementing high-availability for SQL Server may incur additional licensing costs. It's recommended that you review the implications of your SQL Server edition usage in a multi-node availability group. For more information, explore the licensing guide provided by Microsoft here.
  • Availability group replicas are created only with synchronous commit as the availability mode.

Configurable parameters:

Server configurationEnvironment variablePDS default value
PDS_AGMONITOR_LEASE_DURATIONdefault15s
PDS_AGMONITOR_RENEW_DEADLINEdefault10s
PDS_AGMONITOR_RETRY_PERIODdefault2s
PDS_AGMONITOR_HEALTHZ_TIMEOUTdefault10s
PDS_AGMONITOR_CHECK_INTERVAL_SECONDSdefault2
PDS_AGMONITOR_MIN_WAIT_BEFORE_FAILOVER_SECdefault0
Was this page helpful?