November 20, 2002 at 10:24 am
My company is using Oracle for big databases and SQLSERVER only for small applications (the biggest I have is 500MB).
We want to impelment a large database in SQLSERVER (hundreds of GB) and I would like to get some examples of large databases installed.
Thanks
November 20, 2002 at 10:37 am
A friend of mine works for a bank which has 500Gb + databases on SQL Server.
November 20, 2002 at 11:20 am
According to his author info, Randy Dyess at Verizon has some VLDB. The single largest is > 2.2 TB.
http://www.transactsql.com/Author.html
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
November 20, 2002 at 6:28 pm
The biggest example is of course at http://www.terraserver.com which was project with SQL 7 initially, not sure what they run now but it is in the TerraBytes of data on a SQL database.
I have several medium databases (2GB-10GB), and 3 Large databases (10, 11 and 32GB), with a bit of tweaking now and then I have had minimal issues.
November 20, 2002 at 6:44 pm
Got one at 800GB
Steve Jones
November 20, 2002 at 6:47 pm
Got one at 800GB
Steve Jones
November 21, 2002 at 10:02 am
FYI, I think Terraserver is running mulitple 1.5+ terrabyte databases.
-Dan
-Dan
November 22, 2002 at 6:32 pm
We may be a better example due to ignorance.
We started SQL Server because it was handy and cheap and we had a few hundred meg of data.
We grew that "data warehouse" to something more worthy of it's name, it's currently around 170G, with quite heavy use.
I came from an Rdb (was DEC, then Oracle) background with big hardware and expensive software and didn't have a lot of hope this would scale well, but it did. While it was on a small server (bought for about $8k) we ran benchmarks with live data against Oracle Rdb running on a $100k Alpha, and in no case did Rdb keep up with SQL Server 7. I've also used Sybase, though am not that knowledgeable there.
We've since expanded to a much heftier server, actually a pair we update in parallel and/or replicate between, and continue to be pleasantly surprised how well it works. It's also been surprisingly stable -- to date we've had no corruption in any data, and very few problems (not zero -- but I'd say very comparable to my experience in Sybase and Rdb in terms of reliability).
It lacks some of the maturity of Rdb -- the documentation "depth" is poor, and on-line maintenance, while dramatically improved over 6.5, is still mediocre in comparison to Rdb 4 years ago. ON the other hand it's a LOT easier to maintain without a Dba.
FWIW, YMMV.
November 22, 2002 at 10:01 pm
I am handling a datawarehousing database of 600 GB of data at HDFC bank (India). Total size of the database is 1TB.
Prakash
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
November 25, 2002 at 9:32 am
Please see: SQL Server 2000 Scalability Project -- Rosetta Genomics 10-Terabyte Human Genome Database at http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp . The data base is expected to grow to 100-Terabyte size.
November 25, 2002 at 10:48 am
Found this in another thread and has some good company listings and what they are doing with SQL. Case studies.
http://www.microsoft.com/sql/evaluation/casestudies/alphalisting.asp
November 26, 2002 at 5:44 am
We are building a DW now that will be about 350 Gig, w/SQLSVR 2000.
December 5, 2002 at 8:55 pm
microsoft.com runs on 16 linked servers, each quite large in size. I saw a pretty neat overview (not TOO much marketing hype) at the local MSDN event they have here about a year ago.
As others have mentioned, terraserver is the Microsoft "proof" that at least SS7 can handle a VLDB.
December 6, 2002 at 8:28 am
Main production server is 1.4T!
Be great!
Michael
Be great!
Michael
December 6, 2002 at 9:43 am
Most of mine average between 25 GB and 280 GB, the exceptions are over a terrabyte each and are datawarehouses.
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy