Data migration time calculation (use case)

Calculate the data migration time for a specific amount of data on a consolidated server.

This use case is based on the following server specifications:

Item

Details

Software

Windows 2012 R2

SQL 2014 R2 latest SP - 9.7 GB

Hardware

CPU: 2 x Quad Core

Memory: 16 GB

Disks - HP System Smart Array:

  • C: Software RAID 1 (140 GB)

  • D: Logs RAID 1 (280 GB)

  • E: DB files, OSP data RAID 5 (830 GB)

    		•

    Before you begin 

    Selected migration method: databases migrated simultaneously.

    Procedure 

    1. Run database queries to retrieve the number of sessions and evaluations.

      The queries returned the following data:

      • LocalContact: 0.34 million sessions

      • CentralContact: 100 million sessions

      • CentralApp: 0.4 million evaluations

      • CentralDWH: 100 million sessions and 0.4 million evaluations

    2. Calculate the data migration time for each subsystem:

       

      Migration method:

      Database

      Data migration plus rebuild mandatory and recent indexes (minutes)

      Data migration plus rebuild all indexes (minutes)

      LocalContact

      A =0.34*9= 3

      A =0.34*9= 3

      CentralContact

      B =100*0.4= 40

      B =100*0.5= 50

      CentralApp

      C =0.4*20= 8

      C =0.4*20= 8

      CentralDWH

      D =(100*0.7)+(0.4*40)= 86

      D =(100*0.8)+(0.4*40)= 96

    3. Since all databases are migrated simultaneously, calculate the total migration time accordingly:

      Index rebuild method

      Total time (minutes)

      Rebuild all indexes

      Max(A,B,C,D)=96

      Rebuild mandatory and recent data indexes

      Max(A,B,C,D)=86