Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: How large can SQLServer scale?

    I'm considering options for a large scale data warehouse. Even though SQL can theorectially scale to 10 Terabytes plus, in practice - will it be able to do it? Has anyone else actually done it? Or should Oracle be used?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    This is blasphemy....

    Oracle

    Scale out not up...

    Get some serious hardware and a lot of cash...

    Why 10 terabytes...

    What the subject matter?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You get into a matter of what makes sense.

    1 gigabyte is trivial. MSDE will eat that alive, and ask for more.

    10 gigabytes is easy. It is beyone the range of MSDE, and probably needs somebody to casually watch over it.

    100 gigabytes is more challenging, you need to at least pay attention to what you are doing. A full time dba starts to make sense.

    1 terabyte requires serious planning. You need to think through what you are doing, have enterprise grade hardware, and leash the bozos so that they don't make a mess of your data.

    10 terabytes is where the systems I know about start to peter out. There are a few dozen of them like Terraserver and Barnes and Noble, but they aren't all that common.

    160 terrabytes is the limit that I know about, although that isn't a public server. It has a small army of DBAs and developers, but it has run for about ten months without a minute of downtime so I'd say that it is "field tested" at the very least.

    -PatP

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    BIG BLUE

    According to Winter Corp., the largest OLTP production database is an IBM DB2 cluster system run by Land Registry. That mainframe-based system is 18.3 terabytes.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •