User Manual

8 Using Adaptive Optimization...................................................................180
Overview............................................................................................................................180
Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization............................................181
Configuring Adaptive Optimization.........................................................................................181
Tier Definition (CPG Name and GiB)..................................................................................182
Schedule........................................................................................................................184
Measurement Hours.........................................................................................................184
Adaptive Optimization Mode............................................................................................185
Adaptive Optimization Active............................................................................................185
Adding an Adaptive Optimization Configuration..................................................................185
Changing an Adaptive Optimization Configuration..............................................................186
Removing an Adaptive Optimization Configuration...............................................................186
Adaptive Optimization Reports...............................................................................................186
Region IO Density Report..................................................................................................186
VV Tiers Report................................................................................................................188
Adaptive Optimization Space Moved Report.......................................................................189
The showvvcpg CLI extension.................................................................................................190
9 Database Schema..................................................................................192
Using The Database Schema..................................................................................................192
Table Versions and Naming Conventions.................................................................................192
Administrative Tables............................................................................................................192
The policy Table..............................................................................................................192
The sampleinserv Table.....................................................................................................192
The system Table..............................................................................................................193
The alertconfig Table........................................................................................................194
The scheduled_report Table...............................................................................................194
The scheduled_report_log Table.........................................................................................195
The adprovconfig Table....................................................................................................195
The adprov_log Table.......................................................................................................196
The ldrgmoves Table.........................................................................................................196
The recentsample Table....................................................................................................197
The Sample Data and Inventory Tables....................................................................................198
The pdspace Table...........................................................................................................198
The pdspaceinv Table.......................................................................................................199
The ldspace Table............................................................................................................200
The ldspaceinv Table........................................................................................................200
The vvspace Table...........................................................................................................201
The vvspaceinv Table........................................................................................................203
The cpgspace Table.........................................................................................................203
The cpgspaceinv Table.....................................................................................................205
Common Performance Table Columns.................................................................................205
Calculating Common Performance Metrics......................................................................207
Service Time Histogram Buckets....................................................................................208
IO Size Histogram Buckets............................................................................................208
The statpd Table..............................................................................................................208
The statpdinv Table..........................................................................................................209
The statld Table...............................................................................................................209
The statldinv Table...........................................................................................................210
The statport Table............................................................................................................210
The statportinv Table........................................................................................................211
The statvlun Table............................................................................................................211
The statvluninv Table........................................................................................................212
The statvvcmp Table.........................................................................................................212
The statvvcmpinv Table.....................................................................................................213
Contents 15