Home > Storage > PowerFlex > White Papers > Deploying Microsoft SQL Server Containers on OpenShift with Dell PowerFlex > OpenShift tuned profile
Following is a sample tuned profile:
Name: custom-mssql
Namespace: openshift-cluster-node-tuning-operator
Labels: <none>
Annotations: <none>
API Version: tuned.openshift.io/v1
Kind: Tuned
Metadata:
Creation Timestamp: 2022-03-31T16:24:00Z
Generation: 1
Managed Fields:
API Version: tuned.openshift.io/v1
Fields Type: FieldsV1
fieldsV1:
f:metadata:
f:annotations:
.:
f:kubectl.kubernetes.io/last-applied-configuration:
f:spec:
.:
f:profile:
f:recommend:
f:status:
Manager: kubectl-client-side-apply
Operation: Update
Time: 2022-03-31T16:24:00Z
Resource Version: 15735959
UID: a75b34e1-2549-4d23-80e2-f9ff92d8c6d8
Spec:
Profile:
Data: [main]
summary=Optimize systems to run SQL server on OpenShift nodes
include=openshift-node
[sysctl]
vm.swappiness=1
vm.dirty_background_ratio=3
vm.dirty_ratio=80
vm.dirty_expire_centisecs=500
vm.dirty_writeback_centisecs=100
vm.transparent_hugepages=always
vm.max_map_count=1600000
kernel.numa_balancing=0
kernel.sched_min_granularity_ns = 15000000
kernel.sched_wakeup_granularity_ns = 2000000
[disk]
readahead=4096
Name: custom-mssql
Recommend:
Match:
Label: node-role.kubernetes.io/worker
Operand:
Debug: false
Priority: 10
Profile: custom-mssql
Status:
Events: <none>