MS SQL SERVER CHECK LIST

Storage
Memory
CPU – 1 socket and 8 vCPU
Disk format 64KB block
Cost Threshold for Parallelism
Max Degree of Parallelism
Instant File Initialization
Power Plan High Performance
Optimize for Ad Hoc Workloads
TempDB Settings
Auto Create Statistics ON
Auto Update Statistics ON
Turn on Trace Flags
- 1118, 2371, 4199, 3226, and 3205
Change Default Database Auto Growth size
- Data File and Log File between 512 MB or 1 GB
SQL Server authentication
Domain AD Service accounts
SQL Server services
- Each SQL Server services should run on a Domain service account
- The Domain account should be least privileges
SA accounts
- Rename the SA account and change the password
- OR disabled the SA account

SQL INDONESIA