Groups > comp.databases.ms-sqlserver > #681

Re: BLOB storage options

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.server
Subject	Re: BLOB storage options
Date	Tue, 27 Sep 2011 22:56:54 +0200
Organization	Erland Sommarskog
Lines	28
Message-ID	<Xns9F6DE9717B25BYazorman@127.0.0.1> (permalink)
References	<3ac80097-f67b-4e86-9062-a1cb4a51b80a@m37g2000yqc.googlegroups.com> <Xns9F6CDD526413FYazorman@127.0.0.1> <d879a6b7-c547-483e-bf63-619c1823c4b2@n15g2000vbn.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="3217"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18INQ8TdpAA19dMrV/dw6sp"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:WGwji6VPEUurgMs87fLAQAU/ZX8=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:681

Cross-posted to 2 groups.

Show key headers only | View raw

Bill E. Hollywood, FL (behrreich@compuserve.com) writes:
> I'm not sure how large the database will be for just data, but I am
> expecting three or four thousand document uploads per month once
> things get going.  Therefore, the file storage and retrieval component
> will not be trivial.  It's hard to say how large the documents might
> be because they could be in many formats.  Let's assume an average of
> 500 kB per document and about 4,000 documents per month -- that gives
> us 2GB per month of just document storage.

500 kB appears a tad high to me, but that is just gut feeling.

But even if we accept this number - after three years the database 
will be 72 GB - provided that documents are kept "forever" and not
archived anywere.

To be honest, I am not sure that this warrants a more complex solution
to make it easier to have a development database, unless are other reasons 
you want a document-less database for development. True, restoring
72 GB takes longer time than restoring 1GB, but it's not an operation
I expect you do very often.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

BLOB storage options "Bill E. Hollywood, FL" <behrreich@compuserve.com> - 2011-09-26 04:14 -0700
  Re: BLOB storage options Erland Sommarskog <esquel@sommarskog.se> - 2011-09-26 21:45 +0200
    Re: BLOB storage options "Bill E. Hollywood, FL" <behrreich@compuserve.com> - 2011-09-27 07:50 -0700
      Re: BLOB storage options Erland Sommarskog <esquel@sommarskog.se> - 2011-09-27 22:56 +0200
        Re: BLOB storage options "Bill E. Hollywood, FL" <behrreich@compuserve.com> - 2011-09-27 15:01 -0700

csiph-web