Allowed configurations
- 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 |
|
| |
|
| |
|
|
|
|
|
|
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.
- 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 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 |