The biggest load of web stress in Spain with several million sales per hour shortly before each football game.
Multilayer infrastructure of valancers, front and 12 synchronized SQL Server base servers implemented with much of the business layer in hundreds T-SQL stored procedures.
The objective of the project carried out by Jaune Sistemas was the migration from SQL Server 2000 to SQL Server 2008R2, reliably ensuring:
- 100% verification of the migrated T-SQL code, with sufficient unit tests to verify the 100% code coverage, record of tests performed and verification of results.
- 100% verification of views and migrated data.
- Increase in performance according to the same stress and load existing in production.
- Perform hot migration in production systems.