SQL Server Performance

Largest sql configuration

Discussion in 'Performance Tuning for Hardware Configurations' started by peggyr, Jun 23, 2004.

Page 1 of 2

  1. peggyr New Member

    We are looking for information on the largest SQL Server configuration you have seen (working) either clustered or non-clustered. How many servers? How big was the database? How was the performance?
    peggyr, Jun 23, 2004
    #2

  2. FrankKalis Moderator

    http://www.wintercorp.com/VLDB/2003_TopTen_Survey/TopTenwinners.asp might be interesting.
    A friend of mine is working with one of the largest installations (OLAP) totalling about 4,8 TB and everything is running smoothly.


    --Frank
    http://www.insidesql.de
    FrankKalis, Jun 23, 2004
    #2

  3. peggyr New Member

    Thank you for the link. Is your friend's DB a clustered instance or single?
    peggyr, Jun 23, 2004
    #2

  4. FrankKalis Moderator

    I forwarded this thread to my friend and asked him to reply. Actually I don't know.

    --Frank
    http://www.insidesql.de
    FrankKalis, Jun 23, 2004
    #2

  5. Crappy New Member

    Greetings.
    Frank's friend here.

    The DB's are running single. Nothing clustered here

    .
    Cheers,
    Crispin
    Crappy, Jun 23, 2004
    #2

  6. SQL_Guess New Member

    Hey Crispin, welcome... Regan from SQLUGZA here <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Well, I knew Crispin's DB was way bigger than those at my previous site ... that was a 165 GB database (that had about 300 GB archived out of it). That was also running on a single instance, btw.<br /><br />Current site's biggest DB is ... 17 GB ... wooweee<br /><br />Panic, Chaos, Disorder ... my work here is done --unknown
    SQL_Guess, Jun 23, 2004
    #2

  7. peggyr New Member

    Crispin - when you say DB's? Do you have several DB's totaling over 4TB? Or several databases, each over 4TB?
    peggyr, Jun 23, 2004
    #2

  8. derrickleggett New Member

    We have several databases spread across multiple servers here. We have 31 instances and 25 database servers. The main production server has 260gb of databases. The largest three databases all average around 40gb, so not too big. There's also 3 archive databases included in that to support those that are around 120gb right now and growing at a fairly fast rate.



    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
    derrickleggett, Jun 23, 2004
    #2

  9. Crappy New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by peggyr</i><br /><br />Crispin - when you say DB's? Do you have several DB's totaling over 4TB? Or several databases, each over 4TB?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />HI,<br /><br />The one production box (My baby [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]) has the 4TB in. It has two main DB's one at about 900GB and one at about 2.5TB. The rest is some "smaller" adhoc db's and free space.<br />There are 5 prod servers here. The other 4 each have about 1TB a piece.<br /><br /><br /><br />.<br />Cheers,<br />Crispin
    Crappy, Jun 24, 2004
    #2

  10. Crappy New Member

    In the interview I was told by on the the techies "Gig is a swear word around here" [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />.<br />Cheers,<br />Crispin
    Crappy, Jun 24, 2004
    #2

  11. derrickleggett New Member

    Need any help there Crispin? Would love to come help you out on that for a few months some day. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
    derrickleggett, Jun 24, 2004
    #2

  12. Crappy New Member

    he he. Come and wave your magic wand [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br />When I started here I was like a kid with a new toy. I did not know where to start and what to do. So many performance things to play with. Finally, all the theory I had could not be put into action. You can tweak all you like but querying a table with 10000 is always fast. Now, I have tables with just shy of two hunder million rows and that's data for 1 month.<br /><br />Performance tuning is my love and I could sit all day playiing with queries and indexes and designs to suck the best out the box. Call me a geek [:I]<br /><br />If you don't mind working for free, I am sure we can find you a desk. Unfortuantly, as been counters do, they think we have enough resources. I was in the office at 6:15 this morning to try and fit more time in.... What you think?<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by derrickleggett</i><br /><br />Need any help there Crispin? Would love to come help you out on that for a few months some day. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />.<br />Cheers,<br />Crispin
    Crappy, Jun 24, 2004
    #2

  13. derrickleggett New Member

    Free......no. <img src='/community/emoticons/emotion-1.gif' alt=':)' /> If I ever visit South Africa though, I'll look you up. I'd love to see what you got and just awe over it for awhile.<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
    derrickleggett, Jun 25, 2004
    #2

  14. Crappy New Member

    Any time [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />.<br />Cheers,<br />Crispin
    Crappy, Jun 28, 2004
    #2

  15. peggyr New Member

    Crispin - is your environment DSS or OLTP?

    Thank you!

    Peggy
    peggyr, Jul 7, 2004
    #2

  16. peggyr New Member

    Crispin - one other question.

    How many DBA's do you have in addition to yourself managing these databases?

    Thanks!
    peggyr, Jul 7, 2004
    #2

  17. thomas New Member

    I have a 60GB database in SQL Server 6.5 which is quite terrifying.

    Tom Pullen
    DBA, Oxfam GB
    thomas, Jul 8, 2004
    #2

  18. anupchintawar New Member

    We have 1 TB database. As per microsoft it is largest in Asia. Microsoft(China) is also supporting this database.

    -Anup
    anupchintawar, Jul 8, 2004
    #2

  19. Slart New Member

    two servers (identical to each other) that has several 1TB databases, one 1.8TB database, totaling 8TB on the server. Everything works fine.
    Slart, Sep 22, 2004
    #2

  20. bradmcgehee New Member

    Anyone here interested in writing up a case study of their SQL Server to share with others on this website? If so, contact me.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Sep 23, 2004
    #2

  21. pfgm New Member

    Hi, Would you recomment AWE in an OLTP database ?
    Are your databases (1TB and more) running on what kind of servers ?



    Saludos, Pablo
    pfgm, Sep 27, 2004
    #2

  22. chopeen Member

    A well-known VLDB is Microsoft's TerraServer.

    The database size is 3.3 TB.

    --

    Marek 'chopeen' Grzenkowicz

    'You're so cute when you're frustrated.' -- Interpol
    chopeen, Sep 28, 2004
    #2
Page 1 of 2

Share This Page