• ASH and AWR - Azure - Oracle

    Stabilizing Migrations to the Cloud with SQL Baselines

    I had a customer who needed to know how to retain performance after migrating to the cloud for SQL execution and I recommended SQL Baselines, but the information was surprisingly missing on how to collect an AWR baseline, THEN export out baselines and post migration, start a import baselines and review performance.   Goal To stabilize performance of Oracle database during migrations to new Azure infrastructure from on-premises environments.  Oracle provides in 12c and above, the ability to create full management baselines of SQL executions, which are a combination of SQL profiles, hints and defined statistical data to ensure performance remains…