• Sat. Mar 6th, 2021

Configuring SQL Server 2017

ByGary Cowan

Mar 16, 2018
Configuring SQL Server 2017

Configuring SQL Server 2017

How that you have installed SQL Server 2017, it is time to get your hands dirty and start to create databases. But before we do that, it is a good idea to configure your SQL Server 2017 environment correctly.

To do this, just Right Click the server and click properties.

Configuring SQL Server 2017
Configuring SQL Server 2017


Once you have done that, the following screen should appear.

Configuring SQL Server 2017
Configuring SQL Server 2017

Here is where you can set some properties for your SQL Server 2017 environment that will help you control the performance, administration and security of your databases.

In the General tab, you can see it just shows you general information about your server that you may need to know from time-to-time.

The Memory tab controls how much of the operating system SQL Server will use. Most of the time, the only option to you need to change on this screen is the Maximum Server Memory option. There are many calculators on the internet on how to work out the correct value, but if you just want a good value, subtract 4-8 gig from the total amount of memory you have on your pc/laptop and put in the value i.e.
So If you have 14 gigabytes installed on your hardware, type in ‘10000’ and that will mean SQL Server will use 10 gigabytes and 4 gigabytes will be used for Windows. You might need to type in a less number if you have other memory intensive software on your hardware.

Processor tab, you don’t usually change anything in this tab so just leave things as default.

Security tab, again you don’t change anything in this tab unless you have a security issue that you need to resolve. In a working environment, you might need to audit more processes in your situation so changing some of the settings for security purposes might need to happen. In a testing environment, I usually leave these as default.

The Connection tab governs how many connections you want your SQL Server to handle and if you’re going to allow remote connections to your server.

The Database Settings tab is where you can set where decide files are stored on your hard drive. Databases have two files when they are created, an MDF file and an LDF File. It is good practice to place this files on different hard drives for performance. In this table, you can set the default location on where this files will be created.

For setting up the environment for testing, you don’t need to change the ‘Advanced’ and ‘Permissions’ tabs but future posts, I will go into more details.

This is just a simple guide on how to configure your SQL Server 2017 environment and will go into more details in future blogs. If there is anything you want me to cover in more detail, just leave a comment below.

Gary Cowan

I have been working with SQL Server for 20 years and have administrated and developed software solutions with SQL Server from SQL Server 6.5 through to SQ Server 2019. I have MCTS, MCP, MCDBA and MCITP Qualifications in SQL Server.

Leave a Reply

Your email address will not be published. Required fields are marked *