July 23, 2009 at 11:55 am
Hello,
Mostly we have tested our OLTP databases with 0.5 TB but we need to spec out a system for 40 TB. We don't have resources (system) to do tests. How we can extraploate and what is the best practice and lookup places.
Till know recommendations are SQL Server 2005 Ent with data partition. We don't know how much memory, cpu or disks required for 40 TB system.
Thanks
July 29, 2009 at 2:11 pm
Considering its a 40TB data - you need to purchase hardware for 2.5 times the data, so that is 40TB * 2.5 = 100 TB. This is considering future data additions, transaction logs and Hardware Parity, RAID 5 Arrays etc etc....
Try to invest in a BladeCenter with a SAS storage attach. If Blade Center seems to be a lot, try getting a Rack Server with Clustering, 64GB ram and 250GB for OS and software base.
July 30, 2009 at 6:42 am
Get expert help. 40TB is a leading edge system and very few people will have the experience to give you useful advice. You will find problems at the 40TB level that most folk have never heard of.
This forum and others may help you decide questions for your RFP, but you should not base a multi-million investment on free advice. You will find that investing $50K on advice will save you a few $100K or more on the solution you implement.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
July 30, 2009 at 6:48 am
kchaluva (7/23/2009)
... we have tested our OLTP databases with 0.5 TB but we need to spec out a system for 40 TB.
I'm a little puzzled about reading "OLTP" and "40 TB" in the same phrase.
Such a large system would be - at least in my mind - much more complicated than a single RDBMS server.
I would love to have the opportunity of knowing a little more about functionality before start guessing.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 30, 2009 at 7:25 am
EdVassie (7/30/2009)
Get expert help. 40TB is a leading edge system and very few people will have the experience to give you useful advice.
Agreed. This is not a reflection on your capabilities or skills. It's just that a 500GB system and a 40TB system are very, very different beasts. It's well worth spending the money to get advice from someone who has experience in that area.
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
July 30, 2009 at 8:23 am
Talk to IBM if you are interested. They helped us with our 30TB system.
July 30, 2009 at 12:17 pm
Please take Ed's advice ... the money you will spend on experienced consultants with the knowledge-base you need will be paltry (50-100k) compared to the millions your servers, SAN storage and backup solution will cost !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 4, 2009 at 3:11 pm
We are in-process to work with Microsoft. Thank you all.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply