Front & back end servers infrastructures

What is the suitable scenario & Specifications of servers to run attendance application which is store up to 120000 records daily. Using web application  & SQL server. Number of concurrent users reach 2000 users resides in three cities.
I need my application works 24/7, so what is the disaster recovery approach should I walk through

please help.
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
That's nothing special if you compare with companies websites that have thousands of visits every day and from all part of the world.
If you don't want to think much about managing that you can just go to a Cloud solution as they offer all these services to you.
Otherwise, you'll need at least a cluster machine with a minimum of 2 nodes, where a node need to be in a different region for DR purpose. Then configure it with the only real High Availability solution that exists for SQL Server, the AlwaysOn.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mohammad Alsolaimanapplication programmerAuthor Commented:
well, thanks Vitor Montalvão for helpen me.
Any advice with the hardware specifications, please!
David Johnson, CD, MVPOwnerCommented:
You say it is an attendance website..  Is the usage spread out during the day or is it an all at once operation during periods of the day?

Try it with 1 16GB 4 core or more computer/SSD for data  with FE/BE on the same computer. Observe results. where are your bottlenecks? do you need more webserver or sql server resources?
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

Mohammad Alsolaimanapplication programmerAuthor Commented:
Hi: Mr. David Johnson
The rush hours are at 08:00 am for check in, & 02:30 pm for chick out.
And as you know I need to have 120000 records daily which is all employees records to update the daily status for each one via over 2000 workstations.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Any advice with the hardware specifications, please!
Not really use to provide any advice on this with the information you shared with us.
It means nothing if the server needs to be up and running for 24x7. I mean, for this it doesn't affect the resources of your server. You might need more servers to provide an high availability solution but that's different.
The number of cities aren't also important for the server size.
120K of new records daily is something that SQL Server can handle easily without the need of much resources. The same for the 2K concurrent users.

From my experience, if there will be a bottleneck, it will occur 99% of the time on the front end servers. What's important is that you provide a fast network as fast disks.
Mohammad Alsolaimanapplication programmerAuthor Commented:
thanks to all of u
Vitor MontalvãoMSSQL Senior EngineerCommented:
Recommendation to close this question by accepting the above comments as solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.