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 auto-growth options for the database.…