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 |
|
adnan8t2
Starting Member
6 Posts |
 Posted - 2010-06-21 : 04:26:36
|
| Dear Readers,According to your experience what we should set the size of following fields while creating a new database.MDF Initial Size = ?LDF Initial Size = ?MDF—-Enable Autogrowth = ?File Growth = ?Maximum File Size = ?LDF—-Enable Autogrowth = ?File Growth = ?Maximum File Size = ?Thanks,Adnan |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-06-21 : 05:12:10
|
It depends on what the database should be used for. And how much you expect the database to grow monthly.There are some rule of thumbs however1) Never use a percentage growth, always use a fixed size growth.2) For better performance with log file, use 8GB as initial size (and file growth) to avoid too many VLF's.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
What are the best practices when creating a new da