How Much SQL Storage Do I Need?

I need to work out how much database space will be consumed through the
Community Server.

I realise that this is a bit of an unknown as no-one really knows how many
people will use the system, or how much information they'll generate.

A rough guesstimate or average consumption per user would be enough to put
forward my case.

Your imput will be much appreciated,

 

Muchas gracias,

Marco

Marco,

This is really impossible to say how much SQL space you will need to use CS even
based on a ratio.

What I (and others) can give you is the current space of our databases then you
can compare sites and get better thoughts. 

If you need information for my site, just ask and I'll answer you then.

Keyvan, that would be great... please let me know how much space you db is, and
traffic stats (visitors per day, registered CS users, etc). Then I'll use this
info and compare it with our current site and provide my finance deparment a
reasonable justification for expenditure. Thank you once again!... M

I have one tip and this one can really make your db grow if you are using
photos, file galleries and file attachments and that is to go into the
communityserver.config file and disable data storage because by default files
are stored in the db and the file system.

Each application has a setting for this and there are 4 of them Gallery, Weblog,
Forums, FileGalleries


<Gallery
            allowEncodedUnicodeCharsInMetadata="true"
            >
                <AttachmentSettings 
                    enableFileSystemStorage="true"
fileSystemStorageLocation="~/photos/storage" 
                    enableDataStoreStorage="false" 
enableDirectLinks="false" 
                    extensions =
"gif,jpg,jpeg,png,bmp,GIF,JPEG,JPG,PNG,BMP,Gif,Jpg,Jpeg,Png,Bmp"
/>
                <CacheSettings 
                    enableFileSystemStorage="true"
fileSystemStorageLocation="~/photos/cache" 
                    enableDataStoreStorage="false" 
enableDirectLinks="false" 
                    />
        </Gallery>

Rick,

I can not say I can recommend turning off the DB storage until the issue with
corrupt attachments is fixed.  At least 10-15% of all my attachments show up as
0x still.  :(

Russ