Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2008-04-21 : 07:02:06
|
| Hi,I've been looking over quite a few of the sql server installations at my new job and I have been noticing that most of them are set up to autogrow the data-files by 1MB unlimited and the log-files by 10% unlimited which is the default settings when creating a new database in SSMS. This is regardless of the database size which in some cases are 400+ GB. I've usually set autogrow to a fixed MB value of around 20% of the current size, but autogrowing a 400GB database by 20% will take a considerable amount of time and could be a killer during peak hours. What would you guys recomend...?--Lumbago |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-21 : 12:00:29
|
| We never set in % for big databases like that. It better to set 512MB (growth) |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-25 : 04:54:12
|
| also if you can pin down the average growth per week, it is better to adjust the size during off peak hours..--------------------keeping it simple... |
|
|
|
|
|
|
Autogrow questions