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.

Capacity and growth considerations

Capacity and growth considerations - SQL Server Tutorial

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

Start my 1-month free trial

Capacity and growth considerations

“

- [Instructor] Considerations for how large your data files are, and how large they can grow, are things you need to understand, not only when installing SQL but more importantly, when you are creating databases on the installed instance. SQL Server allows you to set the initial size during the creation of the database, or you can accept the defaults, in this case which is eight megabytes. This size determines how much data you can actually store in the database. We can also expand the size of the data files to increase the storage space, or shrink them later to decrease the storage space. But proper planning ahead of time really is crucial to supporting your database performance. Keep in mind that by default, data files will grow as required until the disc is full. Note that the max size in this particular instance is set to unlimited. You can choose different database growth options, such as manually expanding the database with a transact-SQL statement later, or setting the…

Contents