What is the default size of an SQL Server database?

Question

When you create a database, the default size is 8MB. The autogrowth setting is 64MB at a time with unlimited growth (SQL Server 2016). By the way, the initial size and autogrowth settings are not the same between SQL Server versions. You can see this in the SQL Server 2016 and SQL Server 2008 R2 screenshots below.

What is the size of database in SQL Server?

SQL Server Database Engine objectMaximum values for SQL Server (64-bit)Database size524,272 terabytesDatabases per instance of SQL Server32,767Filegroups per database32,767Filegroups per database for memory-optimized data1

What is the default SQL Server database?

master - keeps the information for an instance of SQL Server. msdb - used by SQL Server Agent. model - template database copied for each new database.

What is the default page size in SQL Server?

As mentioned, in SQL Server, the page size is 8-KB. This means SQL Server databases have 128 pages per megabyte. Each page begins with a 96-byte header that is used to store system information about the page.

What is a good size for a database?

Databases don't grow in off hours either - by definition they do it when they're being hit. Pick something reasonable for your expected data load - say 50-200MB. DBAs everywhere will rest a little easier knowing there's one fewer DB with an auto-grow percentage.

Expert · Answer