August 13, 2025 at 1:53 pm
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly reports have started showing regular growth events for the following database files (see attached).
Firstly, what databases are these? I'm familiar with model, master, msdb and tempdb (all of which are visible in SSMS under System Databases), but what are the model_replicatedmaster and model_msdb databases?
Secondly, I want to increase the autogrowth amounts to avoid such frequent growth events in our nightly reports. But I'm not sure how to do this for these particular databases. Is it even possible to change the autogrowth settings for these databases? Or should we just exclude these databases from our reports?
Thank you.
August 14, 2025 at 6:03 am
Hm,
if you search via google, this was the first hit:
https://seangallardy.com/model_msdbdata-and-log-model_replicatedmaster-and-log-what-are-they/
I think you will not be able to change the autogrowth settings for such a system database.
good luck,
Andreas
August 14, 2025 at 6:55 am
Did you perform a SQL Server upgrade (cumulative update) on your SQL2022 ?
If not, at what frequency do you notice these small grow events ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 14, 2025 at 7:46 am
We performed in-place upgrades of our SQL Server 2016 instances to 2022, and then patched to the latest build and are continuing to keep up-to-date. We are currently running the following.
Microsoft SQL Server 2022 (RTM-CU20-GDR) (KB5063814) - 16.0.4210.1 (X64)
Jul 11 2025 13:04:02
Copyright (C) 2022 Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)
We are not seeing the growth events daily, but still reasonably frequently (every few days).
We are not using AlwaysOn Availability Groups.
It sounds like we will just need to filter out/ignore the growth events for these new databases.
August 14, 2025 at 12:10 pm
I've only seen these dbs file grow during application of cumulative updates.
So, I've never worried about them
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply