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
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.
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.
answered May 17 at 09:22 AM