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 |
|
keithc1
Yak Posting Veteran
88 Posts |
 Posted - 2004-06-13 : 16:49:06
|
| Hey all I am logging heavy to sql via ISA firewall, what I want to do is get estimation for what my dail disk space needs will be and plan accordingly by either logging less or allocating more space. The below formula i found is was reccomended for use. Space_Reqd = Number of daily records * Record lengthHow would I determine Daily records and Record Length?ThanksKeithc MCSE MCSA |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-06-13 : 19:12:03
|
| Keithin answer to your questions - how many rows will you be inserting each day ?the record length is the row size, post your table structure and someone will work it out for you .. or you could look on BOL to see what each datatype uses; dont forget to add the size of the non-clustered indexes.Graham |
 |
|
|
|
|
|
Determining Est Database Size