10 database schema – HP 3PAR System Reporter Software User Manual

Page 16

Advertising
background image

Selecting an HP 3PAR Storage System for Adaptive Optimization................................................179
Configuring Adaptive Optimization.........................................................................................179

Tier Definition (CPG Name and GiB)..................................................................................180
Schedule........................................................................................................................182
Measurement Hours.........................................................................................................182
Adaptive Optimization Mode............................................................................................183
Adaptive Optimization Active............................................................................................183
Adding an Adaptive Optimization Configuration..................................................................183
Changing an Adaptive Optimization Configuration..............................................................184
Removing an Adaptive Optimization Configuration...............................................................184

Adaptive Optimization Reports...............................................................................................184

Region IO Density Report..................................................................................................184
VV Tiers Report................................................................................................................186
Adaptive Optimization Space Moved Report.......................................................................187

The showvvcpg CLI extension.................................................................................................188

10 Database Schema.................................................................................190

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

The policy Table..............................................................................................................190
The sampleinserv Table.....................................................................................................190
The system Table..............................................................................................................191
The alertconfig Table........................................................................................................192
The scheduled_report Table...............................................................................................193
The scheduled_report_log Table.........................................................................................193
The adprovconfig Table....................................................................................................193
The adprov_log Table.......................................................................................................194
The ldrgmoves Table.........................................................................................................194
The recentsample Table....................................................................................................195

The Sample Data and Inventory Tables....................................................................................196

The pdspace Table...........................................................................................................196
The pdspaceinv Table.......................................................................................................197
The ldspace Table............................................................................................................198
The ldspaceinv Table........................................................................................................198
The vvspace Table...........................................................................................................199
The vvspaceinv Table........................................................................................................201
The cpgspace Table.........................................................................................................201
The cpgspaceinv Table.....................................................................................................203
Common Performance Table Columns.................................................................................203

Calculating Common Performance Metrics......................................................................205
Service Time Histogram Buckets....................................................................................206
IO Size Histogram Buckets............................................................................................206

The statpd Table..............................................................................................................206
The statpdinv Table..........................................................................................................207
The statld Table...............................................................................................................207
The statldinv Table...........................................................................................................208
The statport Table............................................................................................................208
The statportinv Table........................................................................................................209
The statvlun Table............................................................................................................209
The statvluninv Table........................................................................................................210
The statvvcmp Table.........................................................................................................210
The statvvcmpinv Table.....................................................................................................211
The statcpu Table.............................................................................................................211
The statcpuinv Table.........................................................................................................212

16

Contents

Advertising
This manual is related to the following products: