Dell Acceleration Appliances for Databases Manuale Utente Scaricare il pdf (Pagina 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).

1 2 ... 75 76 77 78 79 80 81 82 83 84 85 ... 88 89

Nessun commento

Dell Acceleration Appliances for Databases Manuale Utente Pagina 80