[dba-SQLServer] VLDBs, the saga - Ramblings only

With the (2) 250g drives I just purchased configured Raid 1 I will now have
a 500g array and a 400g array.  I will be breaking the db horizontally as
discussed in the url you provided earlier.  That will at least allow me to
get it in place.

I already have 2gb RAM which is all the motherboard can handle, and which
SQL Server uses quite well.

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Sunday, August 29, 2004 10:49 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] VLDBs, the saga - Ramblings only


>> If I can in fact do this at all on the class machines available to me
it should be fun.  It has been a much bigger challenge than I expected I can
tell you that.

We tried to caution you :) Big databases demand big hardware. There are no
shortcuts (i.e. compressed drives, etc.). For 65M rows I would want at least
800GB of space and as much RAM as the box can handle. There are threshholds
involved here, though. Go past 8GB for example and you have to reconfigure
everything so SQL Server can exploit the RAM. I don't have an URL handy
concerning this, but this is a well-known issue. If you want to do some
reading on this subject, I'll look for an URL for you.

A.