• 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


10 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t