beautypg.com

HP 3PAR System Reporter Software User Manual

Page 326

background image

10.34

The Sample Data and Inventory Tables

3PAR System Reporter User’s Guide

System Reporter 2.8

Although in principle it was not necessary to store the difference values (d_rcount for

example), since these can be derived from previous samples of the same object, in practice

having the difference values stored in the data tables greatly simplifies the queries and

improves the performance of the queries. As described in the comment for the begin column

in

Table 10-19

, the differences are only valid when the objects have the same begin time.

d_rsize15

DOUBLE PRECISION NOT

NULL

Difference between rsize15 value from last

sample for same object.

wrsize0

DOUBLE PRECISION NOT

NULL

Number of writes in IO size bucket number

0 (512 bytes).

d_wsize0

DOUBLE PRECISION NOT

NULL

Difference between wsize0 value from last

sample for the same object.

...

...

...

wsize15

DOUBLE PRECISION NOT

NULL

Number of writes in IO size bucket number

16 (16MiBytest).

d_wsize15

DOUBLE PRECISION NOT

NULL

Difference between wsize15 value from

last sample for same object.

Table 10-19. Common Performance Columns

Column

Type

Comment