beautypg.com

8 using adaptive optimization, 9 database schema – HP 3PAR StoreServ 7000 Storage User Manual

Page 15

background image

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