Adjust autogrow setting for your database files

I very frequently see too small autogrow value for database files. Even the default in many cases. The defaults prior to SQL Server 2016 are 1 MB for data files and 10% for log files, adjusted to a little bit better values in 2016. One of the tings I often do when I start working on a SQL Server is to adjust the values to something more reasonable.

I have been wanting to automate this for a long time, but other things got in between. But now I have finally created my sp_dbfiles_autogrow procedure. (I’m sure I’m not the first one, but I wanted my own.) It creates and populates a table with the values to generate, based on the current size for the database file, and end result is that it outputs the ALTER DATABASE commands as text (using PRINT). I.e., it doesn’t really change anything, only generate the commands. You can find the procedure here. All comments and bug findings are of course welcome!

 

10 Replies to “Adjust autogrow setting for your database files”

  1. Alright, football fanatics, listen up! Tylekeo188bet has got the odds you need to make those winning predictions. I’ve been studying the form and putting my knowledge to the test. Lets get that profit. tylekeo188bet

  2. Yo, wanted to chime in about 66win9. This site is decent. They have a good variety of games, and navigation isn’t too bad either. Bonus structure isn’t the best, but it is functional. Worth a check on your own accord 66win9.

  3. Alright, so I was browsing around and stumbled upon ole777slot. The slots are pretty cool, got a few wins already! Worth a shot if you’re looking for something new. Find it at ole777slot.

  4. Hey guys, checked out jl44 the other day. Not bad, not bad at all. Quick registration and some fun games. If you are looking new platform play check the jl44 at jl44.

Leave a Reply

Your email address will not be published. Required fields are marked *