Hi,
We have a unique situation that presents some problems. We have an exam making website for schools. That means the website would be used like less than 1% capacity during the month except couple of days usually evening for a few hours with %100 percent capacity when a few thousand students take the exams.
When a school schedule an exam let say that should start between 9:00 PM- 9:02PM for 3000 students, suddenly usage will spike up. Usually students will come at last minute. So the website user count suddenly increase from a few users to a few thousand users in a few minutes. Our exam page is also very database demanding.
In addition to these technical problems, the cost is also very critical for us, since our currency is very weak against dollar. We can quickly go down with wrong configuration.
So, the requirements we have:
1.) The website normally would be used by a few users and can be able to increase its capacity to support a few thousand users in couple of minutes during the exams. The time is very critical here because the schools want the students to start the exams at the same time for preventing cheating. So when the students come, suddenly, the websites capacity (servers, db etc.) must have already been increased the support high demand. Is it possible to scale up capacity in couple of minutes or would it requires some kind of warm up to increase number of servers etc.
2.) This capacity increase should also be supported SQL Server database and if possible should decrease when exams finished.
3.) When the exams over, there will be very few users so that the capacity for the web and database should be lowered to their minimum to lower the cost, since the high capacity won't be needed.
Cloud is designed for scalability. However in our case we need very quick scale up and also scale down.
As I said cost is also very critical for us. How can this web app be configured or setup to auto scale up and down in Azure.
Thanks in advance,