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