From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Configure instance properties continued

Configure instance properties continued - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Configure instance properties continued

“

- [Narrator] In our previous video for the instance properties, we focused on the memory processors security and connection settings. Now let's take a look at the remaining settings. And the first one we'll focus on here are the database settings. Now again, these are specific for the data that we're storing on this instance of SQL server. Our first option is the Default index fill factor. And in order to understand how this applies to the data and how it impacts our SQL server, we need to understand how SQL server stores the data. Data is stored on the file system in what are known as pages. And by specifying our index fill factor we determine how SQL server will make each page when it comes to a new index, using our existing data. So, in other words, the fill factor will affect performance because SQL has to take time to split the pages when they fill up. So a page is only so large. And typically it's around a 64 kilobyte size. When that page fills up, SQL has to now create a new…

Contents