Post reply

examples of large databases

  • November 20, 2002 at 10:24 am

    #58686

    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

    #441857

    A friend of mine works for a bank which has 500Gb + databases on SQL Server.

  • November 20, 2002 at 11:20 am

    #441865

    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

    #441920

    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

    #441922

    Got one at 800GB

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • November 20, 2002 at 6:47 pm

    #441924

    Got one at 800GB

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • November 21, 2002 at 10:02 am

    #441995

    FYI, I think Terraserver is running mulitple 1.5+ terrabyte databases.

    -Dan


    -Dan

  • November 22, 2002 at 6:32 pm

    #442187

    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

    #442190

    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

    #442298

    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

    #442323

    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

    #442412

    We are building a DW now that will be about 350 Gig, w/SQLSVR 2000.

  • December 5, 2002 at 8:55 pm

    #443405

    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

    #443471

    Main production server is 1.4T!

    Be great!

    Michael


    Be great!
    Michael

  • December 6, 2002 at 9:43 am

    #443484

    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