15.10 - ResUsageSvdsk Table Migration Columns - Teradata Database

Teradata Database Teradata Virtual Storage
prodname
Teradata Database
vrm_release
15.10
category
Configuration
featnum
B035-1179-151K

Migration columns, a subcategory of the ResUsageSvdsk table statistics, identify the number of cylinders that migrated to a different location on a device as well as the time, in centiseconds, of all migration I/Os used, incurred, or saved during the log period.

Note: Each allocation is for a cylinder of data. Cylinders are also known as extents. Therefore the column names begin with Ext for extent.

 

Column Name

Mode

Description

Data Type

ExtMigrateFaster

count

Number of cylinders migrated to faster locations (that is, migrations whose gross benefits are positive) for the associated AMP.

The following formula calculates a Slower Migration value, which is the number of cylinders migrated to slower locations:

SlowerMigration = ExtMigrateTotal - ExtMigrateFaster

Cylinders are migrated to slower locations to make room for hotter cylinders to replace them.

FLOAT

ExtMigrateIOTimeCost

count

Estimates the total cost, in centiseconds, incurred by migration
I/Os completing during the log period, where cost is the extra time waited by all non-migration I/Os as a result of the migration
I/O.

FLOAT

ExtMigrateIOTimeBenefit

count

Estimates the total I/O time savings achieved by migrations completing in the log period. The I/O time savings include the improvement in response time caused by the new data arrangement up to the time horizon.

This value does not include the cost of the migration I/Os and is a gross benefit, not a net benefit.

FLOAT

ExtMigrateIOTimeImprove

count

Estimates the percent improvement in average I/O response time due to migrations completing in the log interval.

For example, if, right before a particular log interval, the average
I/O response time was 10 milliseconds (ms), then the migration logs an ExtMigrateIOTimeImprove value of 10% in this interval. The average I/O response time after the log interval should be (100%-10%)*10ms = 9ms. Migration then logs an ExtMigrateIOTimeImprove of 1% in the next interval. The average I/O response time in the new log interval is (100%-1%)*9ms = 8.91ms.

ExtMigrateIOTimeImprove is only an estimate. Its permanent improvement remains in effect as long as the workload does not change and newer migrations do not significantly alter the data arrangement.

When the workload changes or new migrations affect data arrangement, response time changes in a nonquantifiable way.

You can use this field to predict the actual system performance for short periods of time and to understand why the migration algorithm is doing what it is doing.

FLOAT

ExtMigrateReadRespTot

count

Migration read I/O response time.

FLOAT

ExtMigrateWriteRespTot

count

Migration write I/O response time.

FLOAT

ExtMigrateTotal

count

Total number of cylinders migrated to a different physical location. For more information, see the ExtMigrateFaster column.

FLOAT