schoolnet benchmarks. schoolnet technical disruptions from october database overload high volume...
TRANSCRIPT
Schoolnet Benchmarks
Schoolnet Technical Disruptions from October
Database overload
High volume
Reporting
Static Content
Schoolnet Assessments by the Numbers
School Year/TypeTotal
Assessments Completed
Completed Online Online %
2013-2014 1,375,409 827,622 60.2%District Benchmark 1,367,083 819,691 60.0%District Benchmark NCEXTEND2 869 480 55.2%School Assessment NCEXTEND2 113 113 100.0%State Benchmark 7,344 7,338 99.9%2014-2015 1,027,470 726,283 70.7%District Benchmark 666,524 395,751 59.4%School Assessment NCEXTEND2 8 8 100.0%State Benchmark 360,938 330,524 91.6%Grand Total 2,402,879 1,553,905 64.7%
Schoolnet Technical Improvements for December and January
• Up to 90 “minor” optimizations and enhancements have been applied to version 16.0
• There are three “major” improvements which will distribute and balance the load on Schoolnet:
– Assessments - Created a dedicated database instance to serve the assessment administration activities
– Assessment Reporting – Created a read-only database instance to serve selected reporting activities
– Static Content - Added a Content Delivery Network (CDN), which will place static content closer to the requester without placing additional burden on the application servers
Long Term Schoolnet Solution
• Migrate to Schoolnet Version 16.2 in spring 2015. – Migrates Assessment Administration functions from SQL
Server to “Cassandra” database, which is a much more scalable database platform.
– Includes additional optimizations and functionality
• Monitor the deployment and performance of Schoolnet Version 16.2 with Cassandra in other state instances
• Conduct extensive functional and load tests of version 16.2 in an upgraded NC test environment that mimics production