Largest MS SQL Server Databases

  • Hi!

    Anyone who knows large (billion+ rows) and publicly available (Internet) projects created with MS SQL Server...

    ...please, share a link here.

    I need to show bosses MS SQL Server's success stories.

    thanks in advance.

    Anton Burtsev

  • Try here - http://sqlcat.com/

    You're probably not going to find large, public databases, but there are really large implementations around. Some examples:

    MySpace

    NASDAQ

    etc

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • There's a slideshow about the MySpace set-up here (from 2009, but still):

    http://www.slideshare.net/markginnebaugh/myspace-data-architecture-june-2009

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly as of the presentation.

    http://passmedia.sqlpass.org/media/24hours/2012_fall/PDF/06.pdf

  • russ.thomas (2/20/2014)


    Here is some more recent info from the SQLCAT team... among some other petabyte monsters and companies they profile the databases running XBOX live which adds 12 TB monthly as of the presentation.

    http://passmedia.sqlpass.org/media/24hours/2012_fall/PDF/06.pdf

    Cool Stuff.

    I'd love to work on one of those 100TB+ databases.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Not I. I'd pass on that job. I like my family and bed.

  • Steve Jones - SSC Editor (2/21/2014)


    Not I. I'd pass on that job. I like my family and bed.

    You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change

  • stormsentinelcammy (2/21/2014)


    Steve Jones - SSC Editor (2/21/2014)


    Not I. I'd pass on that job. I like my family and bed.

    You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change

    You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?

    Yikes.

  • Steve Jones - SSC Editor (2/21/2014)


    stormsentinelcammy (2/21/2014)


    Steve Jones - SSC Editor (2/21/2014)


    Not I. I'd pass on that job. I like my family and bed.

    You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change

    You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?

    Yikes.

    Can you imagine the DBA yard stick coming at them to slap their hands?:hehe:

    Yeah - there would be some pain. But there is a lot of learning potential too.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Agreed. Architecting, that would be fun. Day to day support? That's another story.

  • Steve Jones - SSC Editor (2/21/2014)


    stormsentinelcammy (2/21/2014)


    Steve Jones - SSC Editor (2/21/2014)


    Not I. I'd pass on that job. I like my family and bed.

    You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change

    You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?

    Yikes.

    you're right but if you have half a brain you shouldn't be truncating a table :), losing data requires some work, restoring the db will require a lot of prayer 🙂

  • SQLRNNR (2/21/2014)


    Steve Jones - SSC Editor (2/21/2014)


    stormsentinelcammy (2/21/2014)


    Steve Jones - SSC Editor (2/21/2014)


    Not I. I'd pass on that job. I like my family and bed.

    You'd hope if you're working on instances that big that you'd be doing more incremental work than a wholesale change

    You're still responsible for the whole thing. Can you imagine someone truncating a table? losing data? Having to restore the db in some way?

    Yikes.

    Can you imagine the DBA yard stick coming at them to slap their hands?:hehe:

    Yeah - there would be some pain. But there is a lot of learning potential too.

    very true, that's what it's all about...learning to deal with a multitude of situations where nothing scares you or surprises you...i'm with you i'd love to work on a db/server of that size if not larger, the learning gained from that would be incredible

  • So, now i'm kind of curious to see what size DBs other members are working with.

    I'm working with a 750 GB database with around 350 million records.

  • Personally, I'm working with 2,659 databases, which add up to about 700GB of data altogether.

    And yes, this is a horrible, horrible design by a vendor :-D. Really, all of these databases could just be tables in a single database (they're even set up to be as such!), but it works. Mostly. Sometimes. If you shake the server once a week or so.

    - 😀

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply