Home » HP Manuals » Storage Devices » HP 3PAR StoreServ 7400 2-node » Manual Viewer

HP 3PAR StoreServ 7400 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 208

Service Time Histogram Buckets, The statpd Table

View all HP 3PAR StoreServ 7400 2-node manuals

Add to My Manuals
Save this manual to your list of manuals

Page 208 highlights

Table 78 Common Performance Metrics for a Sample Row (continued) Metric Write KBytes/sec Total KBytes/sec Read service time (millisec) Write service time (millisec) Total service time (millisec) Read IO Size (KBytes) Write IO Size (KBytes) Total IO Size (KBytes) Queue length SQL Expression CASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0 END CASE WHEN d_now > 0 THEN (d_rbytes + d_wbytes)* 1000.0/d_now ELSE 0 END CASE WHEN d_rcount > 0 THEN d_rticks / (d_rcount * 1000.0) ELSE 0 END CASE WHEN d_wcount > 0 THEN d_wticks / (d_wcount * 1000.0) ELSE 0 END CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rticks + d_wticks) / ((d_rcount + d_wcount) * 1000.0) ELSE 0 END CASE WHEN d_rcount > 0 THEN d_rbytes / (d_rcount * 1000.0) ELSE 0 END CASE WHEN d_wcount > 0 THEN d_wbytes / (d_wcount * 1000.0) ELSE 0 END CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rbytes + d_wbytes) / ((d_rcount + d_wcount) * 1000.0) ELSE 0 END CASE WHEN qlen > 0 THEN qlen ELSE 0 END The check for qlen > 0 is because qlen < 0 indicates that qlen is invalid for that sample. Busy% AVG(CASE WHEN ((d_now > 0) AND (d_busy < busy)) THEN (d_busy * 100.0/d_now) ELSE 0 END) Service Time Histogram Buckets The service time range corresponding to each of the rhist and whist buckets depends on the version of the HP 3PAR OS (os_rev column in the system table, see "The system Table" (page 193)). For os_rev prior to 2.2.2, the nth bucket (rhistn and whistn) correspond to service times from the previous bucket to (2n*4.096/mhz) millisec where mhz is the mhz column in the system_3 table (see "The system Table" (page 193)). This means that service time histograms from systems with different CPU frequencies could not be correctly aggregated. Beginning with the 2.2.2 release, the buckets were made independent of the CPU frequency, and the nth bucket (rhistn and whistn) corresponds to service times from the previous bucket to (2n-7) millisec. IO Size Histogram Buckets There are 16 IO Size buckets correspond IO sizes 512 bytes to 16 MiBytes. The nth bucket holds the count for IO Sizes from the previous bucket's max size to 512 * 2n bytes. The statpd Table The statpd__4 table holds physical disk (PD) performance data samples. Table 79 statpd__4 Table Column tsecs sys_uid pdid port_n Type Comment INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. INTEGER NOT NULL The physical disk ID. INTEGER NOT NULL The node that the disk's primary port is connected to (the "n" part of n:s:p). 208 Database Schema

Section	Page
HP 3PAR System Reporter 3.1 Software	1
Contents	7
1 Overview and Features	17
User Interfaces	17
About System Reporter	17
Configuring System Reporter Policy Settings	18
Choosing a Method for Accessing Reports	18
Creating Customized Reports	19
Formatting Reports for Presentation	21
Customizing the Reporting Format	21
Generating Email Alerts	21
Accessing Report Data using Web Queries	21
Using the Database Schema to Build Custom Reports	22
Analyzing and Optimizing Storage Utilization	22
2 Installation, Configuration, Update, and Removal	23
Before You Begin	23
System Reporter CD Contents	23
System Requirements	24
Using the System Reporter Sizing Spreadsheet	25
System Reporter Components	26
Installing the System Reporter Components	27
Required Components	27
Optional Components	28
Installing the Web Server	29
Installing the Database Server	30
Choosing the Appropriate Database	30
SQLite	30
Microsoft SQL	31
MySQL	31
Oracle	31
Installing and Setting Up the Microsoft SQL Server Database (Optional)	32
System Reporter Host Configuration	32
Installing and Setting Up the MySQL Database (Optional)	37
Installing MySQL Server	37
Configuring the MySQL Database	38
Setting the max_allowed_packet parameter	39
Creating MySQL Users and Schema	39
Setting Up the Oracle Database (Optional)	40
Creating an Oracle database	40
Creating the Oracle Users for System Reporter	40
Creating the Oracle Net Service	41
Installing or Upgrading the System Reporter Tools	42
Installing or Upgrading System Reporter Tools on Windows	42
Installing System Reporter Tools on Linux	45
Adding Storage Systems	46
Setting File Permissions (Optional)	47
Verifying Installation	47
Installing the Excel Client (Optional)	47
About Apache HTTP Server Authorization and Access Control	48
Removing the System Reporter Components	49
Removing the System Reporter Tools on Windows	49
Removing the System Reporter Tools on Linux	50
Removing the MySQL Database (Optional)	50
3 Getting Started	51
Accessing the Main System Reporter Interface	51
System Reporter Main Menu Window	51
Getting Help	53
Using the Object Selection Controls	53
Simple Selection List	53
Filtered Multi-Selection Control	53
Accessing the Optional Excel Client	54
Starting the System Reporter Excel Client	54
Setting the Security Level for Excel	55
Setting the Security for Excel 2003	55
Setting the Security Level for Excel 2007	56
Connecting to the Web Server from the Excel Client	58
Changing the Excel Client Server and Resetting the Workbook	60
Changing the Web Server	60
Resetting the Workbook	60
Accessing the Excel Client Query Log	60
Deleting Excel Sheets	60
Deleting Menu Sheets	60
Deleting Data Sheets	61
Deleting the Query Log	61
Saving and Exiting the Excel Client	61
4 Accessing and Creating Reports	63
Accessing Quick Reports	63
Accessing Scheduled Reports	64
Creating Custom Reports	65
Building the Report Menu	66
Sample Resolution	67
Report	67
Select Systems	68
Select Domains	68
Generating the Report	68
Controls Available by Report	71
Report Selection	75
Standard Report Types	75
Select Summary Columns	81
Compare	81
Max. Number	82
Select Peak	82
Group By	82
Order By	83
Low Bucket	84
High Bucket	84
Sum End Buckets	84
Time Selection	84
Reload After (mins)	84
Begin/At Time	84
End Time	85
Count	85
Object Selection	85
Select PDIDs	86
Include Chunklets	86
Select Cage IDs	86
Select Disk Types	86
Select Disk Speed	86
Include PDs in States	87
Select Usr CPGs	87
Select Snp CPGs	87
Select CPGs	88
Select LDs	88
Select RAID Types	88
Select LD Usage	88
Select LUN	89
Select VVs	89
Select Prov Types	89
Select VV Types	90
Select Port Types	90
Select Port Rates	90
Select Ports (n:s:p)	90
Select Hosts	91
Select Nodes	91
Select To Nodes	91
Select Queues	91
Format Selection (Web interface only)	92
Report Information	92
Chart Lib	92
Chart Types	93
Chart X Pixels	97
Chart Y Pixels	97
Time Labels	97
Legend Position	97
Time Format	97
Select Space Unit	98
Working with Excel Charts	98
Choosing a Chart Type	98
Refreshing Charts	99
Retaining Charts	100
Exporting Executable Reports	101
Customizing Excel Reports	101
Adding Custom Columns to a Data Sheet	102
Creating a Custom Chart	102
Saving Customized Settings	103
5 Interpreting Report Metrics	104
Summary Report	104
Space Reports	107
PD Space Reports	107
CPG Space Reports	107
LD Space Reports	108
VV Space Reports	108
Performance Reports	109
Common Performance Metrics	109
VV Cache Performance Reports	110
Node Cache Performance Reports	110
CPU Performance Reports	111
Link Performance Reports	111
Adaptive Optimization Reports	112
6 Configuring the System Reporter Policy Settings	113
Accessing the System Reporter Policies	113
Configuring Sampling Policies	113
Compacting Databases	114
Editing Sampling Policies	115
Adding, Removing and Re-Configuring HP 3PAR StoreServ Storage Systems	116
Adding a Storage System	116
Verifying Addition of a Storage System	116
Removing a Storage Server	116
Re-Configuring a Storage Server Sampling	117
Configuring Rules for Email Alerts	118
Adding an Alert Rule	118
Changing an Alert Rule	118
Removing an Alert Rule	119
Alert Rule Parameters	119
Data Table	119
Resolution	120
System	120
Metric	120
Direction	121
Limit Value	121
Limit Count	121
Condition	121
Condition Value	122
Recipient	122
Example of an Alert Rule	122
Scheduling Reports	122
Adding a Scheduled Report	123
Changing a Scheduled Report	124
Removing a Scheduled Report	124
Configuring Adaptive Optimization	124
About File Permissions	125
Modifying the Apache HTTP Server Configuration Files	125
7 Web Queries	127
About Web Queries	127
Data Format Version Report	127
About Reports and Options	128
Report Options	129
category	129
example:	129
compare	129
values:	129
example:	131
comparesel	131
values:	131
table	132
values:	132
example:	132
refresh	132
values:	132
example:	133
charttab	133
values:	133
example:	133
charttype	133
values:	133
example:	134
graphx	134
value:	134
example:	134
graphy	134
value:	134
example:	134
graphlegpos	135
value:	135
example:	135
tableformat	135
value:	135
example:	135
alllabels	135
values:	135
example:	136
timeform	136
values:	136
example:	136
begintsecs	136
value:	136
example:	137
endtsecs	137
value:	137
example:	137
groupby	137
values:	137
example:	139
orderby	139
values:	139
example:	141
histbegin	141
values:	141
example:	142
ldspaceunit	142
values:	142
examples:	142
pdspaceunit	142
values:	142
examples:	143
vvspaceunit	143
values:	143
examples:	143
selcageid	143
value:	144
examples:	144
selchunks	144
values:	144
example:	145
selcpg	145
value:	145
example:	145
selusrcpg	145
selsnpcpg	145
seldisktype	146
value:	146
example:	146
seldiskspeed	146
value:	146
example:	146
seldomain	147
value:	147
example:	147
selhost	147
value:	147
example:	147
selld	148
value:	148
example:	148
sellduse	148
values:	148
example:	149
selnode	149
value:	149
example:	149
selnsp	149
value:	149
example:	150
selpdid	150
value:	150
example:	150
selpdstate	150
values:	150
example:	151
selporttype	151
values:	151
example:	151
selraidtype	151
values:	151
example:	152
selsys	152
values:	152
example:	152
selvv	152
values:	152
example:	153
selvvtype	153
values:	153
selprovtype	153
values:	153
Chartlib	154
Maxgraph	154
Report Types	154
Summary Report	154
summary	154
example:	154
Space Reports	155
pd_space_time	155
example:	155
pd_space_group	155
example:	155
ld_space_time	155
example:	155
ld_space_group	155
example:	155
vv_space_time	156
example:	156
vv_space_group	156
example:	156
vv_space_time	156
example:	156
vv_space_group	156
example:	157
Performance Reports	157
pd_perf_time	157
example:	157
pd_perf_group	157
example:	157
pd_svt_hist	157
example:	157
pd_svt_histvstime	158
example:	158
port_perf_time	158
example:	158
port_perf_group	158
example:	158
port_svt_hist	158
example:	159
port_svt_histvstime	159
example:	159
ld_perf_time	159
example:	159
ld_perf_group	159
example:	159
ld_svt_hist	159
example:	160
ld_svt_histvstime	160
example:	160
vlun_perf_time	160
example:	160
vlun_perf_group	160
example:	160
vlun_svt_hist	160
example:	161
vlun_svt_histvstime	161
example:	161
vv_cmp_time	161
example:	161
vv_cmp_group	161
example:	161
cpu_perf_time	161
example:	162
cpu_perf_group	162
example:	162
Adaptive Optimization Reports	162
regiodensity	162
regiondensity example	162
regmoves	162
regmoves example	162
vvtier	162
vvtier example	163
Options Available by Report	163
Objects Present Reports	169
objectpres= cageid	170
example:	170
output:	170
objectpres= cpg_name	171
example:	171
output:	171
objectpres= diskspeed	171
example:	171
output:	172
objectpres= disktype	172
example:	172
output:	172
objectpres= domain_name	172
example:	172
output:	173
objectpres= host_name	173
example:	173
output:	173
objectpres= ld_name	173
example:	173
output:	174
objectpres=node	174
example:	174
output:	174
objectpres=pdid	174
example:	175
output:	175
objectpres=port	175
example:	175
output:	175
objectpres= system	176
example:	176
output:	176
objectpres= vv_name	176
example:	176
output:	176
objectpres= vv_name_nosnap	177
example:	177
output:	177
objecctpres= porttype	177
example:	178
output:	178
sample_times	178
example:	178
output:	178
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
The statcpu Table	213
The statcpuinv Table	214
The statlink Table	214
The statlinkinv Table	215
The statldrg Table	215
The statldrg_timeinv Table	216
The perf_timeinv Table	216
The space_timeinv Table	216
10 Troubleshooting System Reporter	217
Troubleshooting Overview	217
Troubleshooting the Sampling Components	217
Sampling Component Log Files	217
Installation Configuration	218

Match case Limit results 1 per page

Table 78 Common Performance Metrics for a Sample Row

(continued)

SQL Expression

Metric

CASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0 END

Write KBytes/sec

CASE WHEN d_now > 0 THEN (d_rbytes + d_wbytes)* 1000.0/d_now ELSE

0 END

Total KBytes/sec

CASE WHEN d_rcount > 0 THEN d_rticks / (d_rcount * 1000.0) ELSE 0

END

Read service time

(millisec)

CASE WHEN d_wcount > 0 THEN d_wticks / (d_wcount * 1000.0) ELSE 0

END

Write service time

(millisec)

CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rticks + d_wticks) /

((d_rcount + d_wcount) * 1000.0) ELSE 0 END

Total service time

(millisec)

CASE WHEN d_rcount > 0 THEN d_rbytes / (d_rcount * 1000.0) ELSE 0

END

Read IO Size (KBytes)

CASE WHEN d_wcount > 0 THEN d_wbytes / (d_wcount * 1000.0) ELSE 0

END

Write IO Size (KBytes)

CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rbytes + d_wbytes) /

((d_rcount + d_wcount) * 1000.0) ELSE 0 END

Total IO Size (KBytes)

CASE WHEN qlen > 0 THEN qlen ELSE 0 END

Queue length

The check for qlen > 0 is because qlen < 0 indicates that qlen is invalid for that sample.

AVG(CASE WHEN ((d_now > 0) AND (d_busy < busy)) THEN (d_busy *

100.0/d_now) ELSE 0 END)

Busy%

Service Time Histogram Buckets

The service time range corresponding to each of the rhist and whist buckets depends on the version

of the HP 3PAR OS (

os_rev

column in the system table, see

“The system Table” (page 193)

). For

os_rev

prior to 2.2.2, the nth bucket (

rhistn

and

whistn

) correspond to service times from the

previous bucket to (2n*4.096/mhz) millisec where

mhz

is the mhz column in the

system_3

table

(see

“The system Table” (page 193)

). This means that service time histograms from systems with

different CPU frequencies could not be correctly aggregated. Beginning with the 2.2.2 release,

the buckets were made independent of the CPU frequency, and the nth bucket (

rhistn

and

whistn

)

corresponds to service times from the previous bucket to (2n-7) millisec.

IO Size Histogram Buckets

There are 16 IO Size buckets correspond IO sizes 512 bytes to 16 MiBytes. The nth bucket holds

the count for IO Sizes from the previous bucket’s max size to 512 * 2n bytes.

The statpd Table

The

statpd_<res>_4

table holds physical disk (PD) performance data samples.

Table 79 statpd_<res>_4 Table

Comment

Type

Column

Sample time in secs. This is the Unix time and is the number of seconds

since 0:00:00 Jan 1, 1970 GMT.

INTEGER NOT NULL

tsecs

A unique identifier for the system instance refers to the uniq_id for the

system instance in the system_3 table.

INTEGER NOT NULL

sys_uid

The physical disk ID.

INTEGER NOT NULL

pdid

The node that the disk’s primary port is connected to (the “n” part of

n:s:p).

INTEGER NOT NULL

port_n

208

Database Schema