- Adam Thurgar
Installing SQL Server - Part 3 Post installation SQL configuration
This is the third part of a series on installing SQL Server.
This is based on an a standalone installation of SQL Server 2017.
This blog focuses on the post installation SQL Server configuration changes.
Changes from the default settings:
- check Browser service is disabled
- change TCP port
- enable named pipes
- change min server memory
- change max server memory
- change index fill factor
- enable compress backups
- change cost threshold for parallelism
- change model recovery model
- change SQL Server Agent history max rows, max rows per job and history retention
- change system databases data and log files initial allocation and autogrowth
- check tempdb data and log files