THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Adjust autogrow setting for your database files

This blog has moved! You can find this content at the following new location:

http://sqlblog.karaszi.com/adjust-autogrow-setting-for-your-database-files/

Published Tuesday, December 20, 2016 11:41 AM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Avid Reader said:

Tibor, thx for the share. Quick question does it recommend a larger auto growth rate for mdfs vs ldfs? Not that I need it but just wondering.

January 4, 2017 12:00 PM
 

TiborKaraszi said:

Sorry for the late reply, it seems email notifications for comments are missing at the moment. If you have instance file initialization, then a data file can grow immensely quicker than a log file. So, yes, we can have a bigger autogrow for data files. I didn't want to complicate my script with this, in the name of Keep It Simple... :-)

February 2, 2017 9:09 AM

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement