SQL build requirement for SharePoint

Series starting blog: SharePoint 2019 small Farm Implementation Series

SQL Server Mandatory Requirements:

In this installation series we are not going to implement SQL server , but you should have below requirements enabled on SQL server.

• Microsoft SQL Server 2016/2017 or 2019 Enterprise Editions ( Standard SQL Licensing does not support PowerBI repot server integrations)

• Please do not install the office clients on these servers.

• Windows Server Page File Size: 2 times of RAM allocation located on C drive

• Windows Server power Plan: High Performance

• Windows Server Reduce Disk I/O: allocate C:\ for system drive, I:\ for index, F:\ for logs, E:\ Data, B:\ Backup

• Latency between servers should be less than 1 ms

• SQL Instance Collation: Latin1_General_CI_AS_KS_WS

• NTFS Allocation Unit 64K

• Max fill factor per index: 80 %

• Auto growth Settings should be always in MB and not %

• Activate Backup compression

• Maximum degree of Parnellism (MaxDOP) =1