Database Reference
In-Depth Information
Figure 10.1
SQL server migration—the big picture.
It's very important to gather a baseline that is representative of the workload. There is
no point in baselining a system at night when all the real work happens during the day,
and vice versa.
Tip
It's very important that the baseline sample you take is a representative
workload.
In addition to system and application performance metrics, the baseline should include
time reference data, such as time of day, day of week, week of month, and month of
year. This is to ensure that seasonal or cyclic anomalies in workload patterns are
captured and understood. If the analysis period doesn't include critical cyclical system
peaks, adjustments will need to be made based on a risk factor during the design and
validation of the virtual infrastructure. System logs can be useful to help provide the
delta of system performance between the baseline during the analysis period and
historical peaks. It is also important to understand the workload. If your sampling
interval is every 5 minutes, and you have the system ramp up every 3 minutes, you might
not capture this peak in your sample set and you will not identify this until you are in
