Home > Storage > PowerFlex > White Papers > Architecting Microsoft SQL Server 2019 Containers on Dell EMC PowerFlex > SQL Server ConfigMap
A Kubernetes ConfigMap is an API object that allows you to store data as key-value pairs. Kubernetes pods can use ConfigMap as configuration files, environment variables, or command-line arguments. ConfigMaps allow you to decouple environment-specific configurations from containers to make applications portable.
This solution uses ConfigMap to pass the SQL Server startup parameters. The following snippet shows the ConfigMap file that is used for this reference architecture:
kind: ConfigMap
apiVersion: v1
metadata:
name: mssql-config
data:
mssql.conf: |
[EULA]
accepteula = Y
accepteulaml = Y
[coredump]
captureminiandfull = true
coredumptype = full
[hadr]
hadrenabled = 1
[language]
lcid = 1033
[filelocation]
defaultdatadir = /var/opt/mssql/data
defaultlogdir = /var/opt/mssqlogs/logs
[control]
WriteThrough=1
AlternativeWriteThrough=1
[traceflag]
traceflag0=652
traceflag1=834
traceflag2=880
traceflag3=1613
traceflag4=2330
traceflag5=2458
traceflag6=3468
traceflag7=3982
This ConfigMap file provides a few important parameters for the SQL Server pod. It defines the default data and log directory path to the pod. It also defines a few important trace flags that are used to improve the SQL Server performance on the containers. The ConfigMap file is an important Kubernetes object that is used to pass the required information to the application deployed.
For more information about the ConfigMap file, see Appendix B.