Consider the following best practices for configuring the Windows Server operating system:
- Use an allocation unit size of 64 KB to format the volume that stores the database files.
- Enable Windows Lock Pages in Memory (LPIM) policy by using a domain user account for the SQL Server service identity. The LPIM policy determines which accounts can use a process to keep data in physical memory. This prevents the Windows operating system from paging out a significant amount of data from physical memory to virtual memory on disk.