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

more ▼

asked Oct 03, 2012 at 03:26 PM in Default

avatar image

830 89 93 95

Where's @Brent Ozar when you need him?

Oct 03, 2012 at 03:49 PM ThomasRushton ♦♦

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.

Oct 03, 2012 at 03:58 PM SirSQL

@SirSQL Frankly, the "200TB database" bit was enough to suggest to me that some real consultancy would be an idea...

Oct 03, 2012 at 04:02 PM ThomasRushton ♦♦

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

Oct 03, 2012 at 04:22 PM sp_lock
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

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?

more ▼

answered Oct 03, 2012 at 04:03 PM

avatar image

40.9k 39 95 168

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...

Oct 03, 2012 at 04:55 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Oct 03, 2012 at 03:51 PM

avatar image

ThomasRushton ♦♦
42.4k 20 60 54

(comments are locked)
10|1200 characters needed characters left

You can start by looking at this document: HP Universal DB Solution

more ▼

answered Oct 03, 2012 at 05:42 PM

avatar image

12.1k 30 36 42

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?

Oct 04, 2012 at 07:19 PM pits
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered May 17, 2013 at 09:22 AM

avatar image

4.5k 13 18 22

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 03, 2012 at 03:26 PM

Seen: 1046 times

Last Updated: May 17, 2013 at 09:22 AM

Copyright 2018 Redgate Software. Privacy Policy