Estimating size of SQL database (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


yogaboy -> Estimating size of SQL database (11/29/2004 14:24:19)

Does anyone know a "back of a fag packet" way of calculating the size of a msSQL2000 database? The database hasn't been built yet in any form, and I haven't had a good look at the dataset - but - I do know that the info to be stored is not large (several short strings, all taken from preset choices, no free text) and the total number of records at max is estimated to be 500,000.

s=ut?? e=mc(squared) [8|]




dpf -> RE: Estimating size of SQL database (11/29/2004 14:45:39)

quote:

The database hasn't been built yet in any form, and I haven't had a good look at the dataset
well this sure isnt my area of expertise but it sounds like trying to estimate the size of a house without # rooms, baths, etc.




yogaboy -> RE: Estimating size of SQL database (11/29/2004 14:57:12)

That is true, but we could all say how big a house would usually be[:D]

There must be some sort of formula or method out there for this? How am I to even calculate the size of a record? There doesn't seem to be anything I can find on this subject...




rdouglass -> RE: Estimating size of SQL database (11/29/2004 14:58:01)

This link might help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp




yogaboy -> RE: Estimating size of SQL database (11/29/2004 15:02:29)

That looks like the thing.

Thanks very much - I'm off to find a calculator and brush up on my maths...




dpf -> RE: Estimating size of SQL database (11/29/2004 15:35:30)

quote:

That is true, but we could all say how big a house would usually be
I wasnt trying to be difficult - it just seemed to me that you were trying to estimate size prematurely but, as usual, rdouglas gave you a good lead ( he usually does). good luck




yogaboy -> RE: Estimating size of SQL database (11/29/2004 16:07:12)

Don't worry dpf, I knew that. In fact, I was grateful somebody didn't reply with a flame - I knew it was a stupid question, but sometimes they're the ones you need to ask![;)]

With what I know it's lucky I'm not proud...[:)]




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625