Overview
In this section, we will cover questions like how big does the master database get, the typical size, and growth of the master database.
Explanation
How should the database and transaction log growth settings be configured for the SQL Server master database?
Growth for master database data and log files should follow most of the same rules that other databases would use. The only difference is that one should not expect significant growth out of a master database data or log file. If the master database files are growing significantly, this would likely indicate misuse of the database.
What is the typical size of the SQL Server master database?
A typical master database has only a 5MB to 10MB data file.
How big does the SQL Server master database get?
There really isn’t a reason for the master database to get significantly larger than the average. If it is larger than that, it would indicate that someone is storing something in the database that would be better served being stored in a user database.
Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.
- MSSQLTips Awards: Author of the Year Contender – 2021, 2022 | Trendsetter (25+ tips) – 2021
I have detected my local SQL Server 2022 (Dev.ed) has master db files: mdf= 17Gb and ldf=15GB.
They have 98%free space inside each of file.
Bu why it is possible?