We are planning on making a dataware house in our
company. The size is approximately 200 to 400 G. We have
to make a recommendation for a database server. I would
love to say "Sql Server". But frankly I'm not very
confident at this point. How many people on this board
have databases larger than 100 G. Is it feasible to do
this on Sql Server ? I dont want to say Sql Server and
have to eat my words later. Any facts are welcome from
live installations > 100 G.
Thanks,
JackWhilst there is more effort required in the design,architecture and
administration of a 500Gb database as compared to a 500MB database, SQL
Server is more than capable of scaling to these database sizes. You might be
interested in having a look at
Rosetta Genomics 10-Terabyte Human Genome Database
http://www.microsoft.com/sql/techin...000/rosetta.asp
Microsoft SQL Server 2000 Scalability Project
http://www.microsoft.com/sql/techin.../wintercorp.asp
RDBMS Performance Tuning Guide for Data Warehousing
http://www.microsoft.com/technet/tr...part5/c2061.asp
SQL Server Megaservers: Scalability, Availability, Manageability
http://www.microsoft.com/technet/tr...plan/SSMSAM.asp
(you might also get more responses by posting this in .server or
.datawarehouse)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jack A" <jacka8@.excite.com> wrote in message
news:0b3101c3c3f5$45e86d90$a501280a@.phx.gbl...
quote:
> Hi Guys,
> We are planning on making a dataware house in our
> company. The size is approximately 200 to 400 G. We have
> to make a recommendation for a database server. I would
> love to say "Sql Server". But frankly I'm not very
> confident at this point. How many people on this board
> have databases larger than 100 G. Is it feasible to do
> this on Sql Server ? I dont want to say Sql Server and
> have to eat my words later. Any facts are welcome from
> live installations > 100 G.
> Thanks,
> Jack
