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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-01-02 : 02:20:59
|
| Dear Experts,i'm going to create a new database for the client, the initial size might be 10GB. so please guide me what will be datafile size and log file size?i'm not creating secondary datafiles. is it ok?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2008-01-02 : 13:36:54
|
| I was always taught as a general rule to create the transaction log file 25% of the intial creation size. So calculate 25% of 10 GB and set that as your transaction log size. Then subtract that amount from 10GB and the difference is your data file size. So when you add the data and log file size you should get 10GB.Now if you have an estimated work load that the database will be servicing then you can adjust the sizes accordingly. I hope this helps...Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-03 : 06:52:40
|
| Thank you SquirrelVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
database estimation for client