Last week I got into a conversation with a colleague about how SQL Server grows the database. We were both fairly certain that the database would grow in specific sized increments. We further assumed that the increment size would match the growth setting on the database. However, we wanted to see it for ourselves. Thus an experiment is born!
Hypothesis
When a database is forced to grow within SQL Server, it will do so in predefined increments rather than one large growth. For example, if a transaction requires 100MB of additional disk space and the growth setting is equal to 1MB, the database would grow 100 times at 1MB each time rather than 100MB for a single time.