question

pits avatar image
pits asked

sql configuration

Dear Experts, I am building system whith sql server where the 200 million users will access the application server. The application server will be linked to sql server/SAN to fetch the data. The database size is 200 TB and there will be one millions of click per second on applicaiton server. To survive these clicks/data request what should be my host sql server BOX configuration? do i need to use two host sql server BOX with load balancer? what should be CPU and RAM of each BOX? Here I am also using 2 node cluster , so what should be the CPU and RAM configuration of each node? Also do i need to use 4 application server BOX or VM with load balancer ? What should be the CPU and RAM for each application server? --- I thought of Two host sql server boxes with 8 core processor and 64gb RAM per BOX,for 2 node cluster with 4 core processor and 32 gb RAM for each node,and for application servers 8 core processor and 64 gb RAM per BOX (total 4 boxes or VM for application server with load balancer)..............please let me know if I am in right direction?Please suggest valid configuraiton. Thank you
configurationhigh-availabilityvldb
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SirSQL avatar image SirSQL commented ·
If you're expecting high performance out of a 200TB database and haven't considered your backup/restore & RPO/RTO strategies you might want to get in some highly paid MS consultants to help you.
4 Likes 4 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Where's @Brent Ozar when you need him?
2 Likes 2 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@SirSQL Frankly, the "200TB database" bit was enough to suggest to me that some real consultancy would be an idea...
2 Likes 2 ·
sp_lock avatar image sp_lock commented ·
When you do finally go live, would you mind providing the infrastructure details? I would love to hear how you implemented such a massive system, what hurdles you came across and how you resolved them
1 Like 1 ·
ThomasRushton avatar image
ThomasRushton answered
I would have a look at Brent Ozar's work on the StackExchange server environment - http://www.brentozar.com/archive/2011/11/how-stackoverflow-scales-sql-server-video/ ...but even that is small beer compared with what you're after. Seriously. Get some paid consultants in from the experts at, say, Microsoft.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
200 million users connected to an application server. You will need more than 4 servers friend. Check out stats on Google.com and see their average workload. Are your numbers legit or just numbers for a project?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
Great point, though I would add that the key question is peak simultaneous users. If you expect any noticable percentage of 200million to be active during peak times, you will need more than 4 servers (unless they are true monsters, and even then...) But if you have 200 million users that are each active for a few minutes a month and well spread out over that time you might have a reasonably small peak load...
0 Likes 0 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
You can start by looking at this document: [HP Universal DB Solution][1] [1]: http://h20195.www2.hp.com/v2/GetPDF.aspx/4AA3-9555ENW.pdf
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pits avatar image pits commented ·
thank you Experts, Greg : thank you,I am thinking to impliment Configuration 3 – DL980 G7 8P,but do i need to have such 4 monsters or more then that? on which I can install sql and work further? Can you / anyone please advise?
0 Likes 0 ·
raadee avatar image
raadee answered
**I think you need to listen to the advise given by several people in this thread. Do not pick HP solution X just like that..** Get somebody that knows how to set up this kind of monster solution to help you. You are asking questions that nobody can answer since you do not provide anywhere near enough information, and even if you could provide all the info necessary the follow up questions from anybody that is trying to help you will be very extensive and hard to answer just like that in a forum. If you are trying to save money by asking this question in here thinking someone will solve your problem by picking out what you need for you, you are in some deeeeep water. Like SirSQL said -> RPO/RTO! And I will add -> you will get fired if you do not listen to SirSQL.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.