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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-06 : 08:36:36
|
| surya writes "Hi.... If i m having the database size 2 G.B then what's the sizes of the the logfile ,index file i have to fix and what size of the hard disk space i have to provide for this size. How to calculate the size of the table." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-03-06 : 15:24:08
|
| As always... it depends. 10% of the data file is a descent place to start with the log, but that's a very general figure. Set it to autogrow and keep a very close eye on it to determine the optimum size. Indexes completely depend on the number of them, the number of rows they contain, and the size of the columns that the clustered indexes cover. There are some tools out there for guestamating sizes, but none of them are 100% accurate.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
how to fix the size of hard disk space