Table size overhead -- how much room does a table take?
Posted on 2008-10-21
For starters, let me say that I'm somewhere below noob on SQL2005, and am fishing for information that I have to provide to others for how much of a server is likely to be consumed. So, forgive my lack of experience.
I have a user who is wanting space on a SQL2005 database for some testing parameter data.
Tables will have 10 to 30 columns, with 15 being typical.
Tables will have 2 to 30 rows, with 10 being typical.
Data will be simple strings, 2 to 80 characters, with 20 being typical.
That means, on average, the 150 cells with about 20 characters, being about 3K of data per table.
I understand that there are additional bytes for string terminations and such, and thus some overhead in simply storing strings. But, as my numbers are estimates, I'm still good with my estimate 3K of real data per table.
If it were Oracle, I would expect to give the user his own db, rather than a schema in an existing db. I would assume that SQL2005 is analogous, but I don't know that. (Which is why I'm here.)
Say there were going to be 150 of these tables. "Real" data consumption would be less than 1/2 MB. With all the overhead, how big a footprint should I expect this to consume on the server? How big a footprint should I expect if there were going to be 2,000 tables, consuming about 6 MB of "real" data?