CASE STUDY / LOGISTICS

Handling
Docker

Business continuity, even when there are no breaks.

A leap in version,
without stopping the port.

We helped a major Italian port migrate its operational database from SQL Server 2008 to SQL Server 2019.

2008Starter version
2019New Platform
24/7Continuous operation

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 CHALLENGE

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.

WHAT WE DID

Tuning before the switch

We evaluated functional and performance differences, simulated the scenario and carried out tuning interventions before migration.

DATA IN HAND

Capture & replay with WorkloadTools

We captured the workload in the starting environment, replayed the candidate environment, and compared time and resources to define priorities and verification criteria.

THE RESULT

An updated platform

The migration has been designed for a 24/7 environment, without changing applications and without requiring service interruptions.

TRUST US