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.
• Once configured, you cannot modify the number of nodes in SQL Server AG on PDS. Therefore, ensure the desired node count is set during the initial creation of Always On availability group.

Configurable parameters:

Server configuration	Environment variable	PDS default value
PDS_AGMONITOR_LEASE_DURATION	default	15s
PDS_AGMONITOR_RENEW_DEADLINE	default	10s
PDS_AGMONITOR_RETRY_PERIOD	default	2s
PDS_AGMONITOR_HEALTHZ_TIMEOUT	default	10s
PDS_AGMONITOR_CHECK_INTERVAL_SECONDS	default	2
PDS_AGMONITOR_MIN_WAIT_BEFORE_FAILOVER_SEC	default	0