Dell Acceleration Appliances for Databases - Manual (Page 80)

of external memory pressure that requires further analysis.
OTHER BEST PRACTICES
• When formatting the partition that will be used for SQL server data files, you should use a
64 KB allocation unit size for data, logs and the TempDB database, as shown below:
• Lock pages in memory. To reduce SQL server paging, grant the service account “Lock pages
in Memory” privileges through the Windows Group Policy editor, for both 32- and 64-bit
servers.
• Adjust the “Degree of Parallelism” option to the number of cores in a single NUMA node,
which is eight or fewer. Test the workload with various degrees of parallelism to arrive at the
best combination.
• The default setting for Number of Worker Threads works well for most configurations.
• To ensure efficient operation, create multiple TempDB files (1 per physical CPU core). Pre-
size the TempDB files and create them in equal sizes.
• For ease of maintenance, create more than one log file (there is no performance gain in
configuring more files).
73