Migrate without stopping the port
The port had to move from SQL Server 2008 to SQL Server 2019 while keeping the database that supports port activities operational.
Business continuity, even when there are no breaks.
We helped a major Italian port migrate its operational database from SQL Server 2008 to SQL Server 2019.
Such a version jump requires attention to the functional and performance differences between the source and target environments. With WorkloadTools, the workload capture & replay tool developed by us, we capture a workload that is representative of the starting environment, with execution times and resource utilization.
We rerun the same workload on the candidate environment and compare the results: where regressions emerge, we intervene with tuning measures before the problem manifests itself in production. New replays allow us to see which combinations of compatibility level, trace flags and server settings offer the best performance.
This method allows us to operate even in 24/7 environments, without modifying the applications and without requiring service interruptions: the tuning interventions have already been verified before the actual migration.
WorkloadTools is now recommended by Microsoft, after the discontinuation of the official tools for workload replay: it is the way we avoid rolling the dice on a 24/7 operating environment.
The port had to move from SQL Server 2008 to SQL Server 2019 while keeping the database that supports port activities operational.
We evaluated functional and performance differences, simulated the scenario and carried out tuning interventions before migration.
We captured the workload in the starting environment, replayed the candidate environment, and compared time and resources to define priorities and verification criteria.
The migration has been designed for a 24/7 environment, without changing applications and without requiring service interruptions.