SQL Server Performance

Largest sql configuration

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

  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?
  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
  3. peggyr New Member

    Thank you for the link. Is your friend's DB a clustered instance or single?
  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
  5. Crappy New Member

    Greetings.
    Frank's friend here.

    The DB's are running single. Nothing clustered here

    .
    Cheers,
    Crispin
  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
  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?
  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.
  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
  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
  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.
  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
  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.
  14. Crappy New Member

    Any time [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />.<br />Cheers,<br />Crispin
  15. peggyr New Member

    Crispin - is your environment DSS or OLTP?

    Thank you!

    Peggy
  16. peggyr New Member

    Crispin - one other question.

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

    Thanks!
  17. thomas New Member

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

    Tom Pullen
    DBA, Oxfam GB
  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
  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.
  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
  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
  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

Share This Page