|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > File sizes in SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
File sizes in SQL Server
|
|
|
| Hi we are a small K12 curriculum company about to move from
small, static HTML sites to a more robust data driven site.
I am trying to figure out what kind of space needs I'm
going to have for our hosting company. I'm hope someone
here will be able to offer a suggestion
The new site, will use ColdFusion (right now, anyway) to
help serve some 100K to 300k records to a site (the idea is
that a student logs in, and she gets a site that is
customized to her needs). We'll use SQL Server as the
database backend for the 100-300K records -- which will
contain only text strings (name, age, friends' names, --
approx 10-15 fields).
Here is my question, is it possible to determine how big
the data file will be beforehand? That is, would I be able
to know now, that I'm safe with 250MB of SQL Server space
or that I'll need 1GB of space? I'm trying to determine our
hosting budget/requirements -- and there's a big difference
in price (of course), depending on our data needs.
So, if there are any rules of thumb on this, I'd appreciate
any help. Thanks.
| |
| Tibor Karaszi 2002-11-21, 8:23 am |
| Josh,
You can calculate if you know your table structure. The info is in Books Online. See
http://msdn.microsoft.com/library/d...s_02_2h45.asp?f
rame=true
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Josh" <josh@topicseducation.com> wrote in message
news:df4e01c2915e$f60596f0$89f
82ecf@TK2MSFTNGXA01...
> Hi we are a small K12 curriculum company about to move from
> small, static HTML sites to a more robust data driven site.
> I am trying to figure out what kind of space needs I'm
> going to have for our hosting company. I'm hope someone
> here will be able to offer a suggestion
>
> The new site, will use ColdFusion (right now, anyway) to
> help serve some 100K to 300k records to a site (the idea is
> that a student logs in, and she gets a site that is
> customized to her needs). We'll use SQL Server as the
> database backend for the 100-300K records -- which will
> contain only text strings (name, age, friends' names, --
> approx 10-15 fields).
>
> Here is my question, is it possible to determine how big
> the data file will be beforehand? That is, would I be able
> to know now, that I'm safe with 250MB of SQL Server space
> or that I'll need 1GB of space? I'm trying to determine our
> hosting budget/requirements -- and there's a big difference
> in price (of course), depending on our data needs.
>
> So, if there are any rules of thumb on this, I'd appreciate
> any help. Thanks.
|
|
|
|
|