beautypg.com

8 using adaptive optimization, 9 database schema – HP 3PAR System Reporter Software User Manual

Page 15

background image

output:.......................................................................................................................179

objectpres= vv_name_nosnap............................................................................................180

example:....................................................................................................................180
output:.......................................................................................................................180

objectpres= porttype........................................................................................................180

example:....................................................................................................................181
output:.......................................................................................................................181

objectpres=qos_name......................................................................................................181

example:....................................................................................................................181
output:.......................................................................................................................181

sample_times..................................................................................................................182

example:....................................................................................................................182
output:.......................................................................................................................182

8 Using Adaptive Optimization...................................................................183

Overview............................................................................................................................183
Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization............................................184
Configuring Adaptive Optimization.........................................................................................184

Tier Definition (CPG Name and GiB)..................................................................................185
Schedule........................................................................................................................187
Measurement Hours.........................................................................................................187
Adaptive Optimization Mode............................................................................................188
Adaptive Optimization Active............................................................................................188
Adding an Adaptive Optimization Configuration..................................................................188
Changing an Adaptive Optimization Configuration..............................................................189
Removing an Adaptive Optimization Configuration...............................................................189

Adaptive Optimization Reports...............................................................................................189

Region IO Density Report..................................................................................................189
VV Tiers Report................................................................................................................191
Adaptive Optimization Space Moved Report.......................................................................192

The showvvcpg CLI extension.................................................................................................193

9 Database Schema..................................................................................195

Using The Database Schema..................................................................................................195
Table Versions and Naming Conventions.................................................................................195
Administrative Tables............................................................................................................195

The policy Table..............................................................................................................195
The sampleinserv Table.....................................................................................................195
The system Table..............................................................................................................196
The alertconfig Table........................................................................................................197
The scheduled_report Table...............................................................................................197
The scheduled_report_log Table.........................................................................................198
The adprovconfig Table....................................................................................................198
The adprov_log Table.......................................................................................................199
The ldrgmoves Table.........................................................................................................199
The recentsample Table....................................................................................................200

The Sample Data and Inventory Tables....................................................................................201

The pdspace Table...........................................................................................................201
The pdspaceinv Table.......................................................................................................202
The ldspace Table............................................................................................................203
The ldspaceinv Table........................................................................................................203
The vvspace Table...........................................................................................................204
The vvspaceinv Table........................................................................................................206
The cpgspace Table.........................................................................................................206
The cpgspaceinv Table.....................................................................................................208
Common Performance Table Columns.................................................................................208

Contents

15