Concurrency and Storage Needs :
Requirements:
We operate on K-12 Online Summative Market.
Our Needs are:
When Kids log-in to take the test, they should be able to login without any issues.
Should be able to store their responses and score them on the fly without much latency.
Should be able handle entire state. If a state decides to test their 8th Graders with High Schoolers on one Morning, System should be capable of handling entire state 8th graders and High Schoolers .
Concurrency Needs vary but 500 K Concurrent Users is good number for us to support.
In simple Terms, COST , SCALE , SPEED and RELIABILITY are our considerations not necessarily in that order.
It should be fast.
It should be reasonably priced.
Data should be safe and Secure. Can’t afford to lose any data at all.
How can we achieve these needs.
Options considered:
Direct Attached Storage
SAN
Fusion IO
SSD’s
Good Primer on Scale Out vs Scale Up:
http://www.brentozar.com/archive/2011/02/scaling-up-or-scaling-out/
Microsoft Article on Scaling Out SQL Server:
https://msdn.microsoft.com/en-us/library/aa479364.aspx
Stack Exchange Decision Making Process on their Storage System. Their needs are pretty similar to our needs.
http://blog.serverfault.com/2011/02/09/our-storage-decision/
Brent Article on Scaling SQL Server :
http://www.brentozar.com/archive/2011/06/scaling-sql-server-growing-out/
Brent Ozar Fusion IO Benchmarking Tool:
http://www.brentozar.com/archive/2010/03/fusion-io-iodrive-review-fusionio/