Home > Storage > PowerFlex > White Papers > Dell APEX Block Storage for Azure: Microsoft SQL Server 2022 Deployment and Performance Best Practices > A3. SQL Server tuning
The following code sample shows some of the SQL Server tuning parameters that are used to run the HammerDB workload tool for the database performance test:
EXEC SP_CONFIGURE 'SHOW ADVANCED OPTIONS', '1'
RECONFIGURE WITH OVERRIDE
EXEC SP_CONFIGURE 'MIN SERVER MEMORY', 0
EXEC SP_CONFIGURE 'MAX SERVER MEMORY', 64000
EXEC SP_CONFIGURE 'RECOVERY INTERVAL','32767'
EXEC SP_CONFIGURE 'MAX DEGREE OF PARALLELISM','0'
EXEC SP_CONFIGURE 'LIGHTWEIGHT POOLING','1'
EXEC SP_CONFIGURE 'MAX WORKER THREADS', 3000 ---- Subject to change depending on different CPU configuration.
EXEC SP_CONFIGURE 'DEFAULT TRACE ENABLED', 0
EXEC SP_CONFIGURE 'COST THRESHOLD FOR PARALLELISM', 50
GO
RECONFIGURE WITH OVERRIDE
EXEC SP_CONFIGURE 'PRIORITY BOOST', '1'
ALTER DATABASE OLTP SET RECOVERY SIMPLE
GO
ALTER DATABASE OLTP SET TORN_PAGE_DETECTION OFF
GO
ALTER DATABASE OLTP SET PAGE_VERIFY NONE
GO