Hp 3PAR System Reporter Software Bedienungsanleitung Seite 206
- Seite / 224
- Inhaltsverzeichnis
- FEHLERBEHEBUNG
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Table 78 Common Performance Metrics for a Sample Row (continued)
SQL ExpressionMetric
CASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0 ENDWrite 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 ENDQueue 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 InFormOS (os_rev column in the system table, see “The system Table” (page 191)). 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 191)). 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 are16 IO Size buckets correspond IO sizes 512 bytes to 16MiBytes. 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
CommentTypeColumn
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 NULLtsecs
A unique identifier for the system instance refers to the uniq_id for the
system instance in the system_3 table.
INTEGER NOT NULLsys_uid
The physical disk ID.INTEGER NOT NULLpdid
The node that the disk’s primary port is connected to (the “n” part of
n:s:p).
INTEGER NOT NULLport_n
206 Database Schema
- User’s Guide 1
- Documentation 7
- Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- 16 Contents 16
- Contents 17 17
- 1 Introduction 18
- Typographical Conventions 19
- Advisories 19
- 2 Overview and Features 20
- Creating Customized Reports 21
- Generating Email Alerts 23
- 24 Overview and Features 24
- Before You Begin 25
- System Reporter CD Contents 25
- System Requirements 26
- System Reporter Components 28
- System Reporter Components 29 29
- Required Components 30
- Optional Components 30
- Installing the Web Server 31
- Microsoft SQL 33
- 6. Click Next 36
- Installing MySQL Server 38
- Creating an Oracle database 41
- Adding Storage Systems 47
- Verifying Installation 48
- 4 Getting Started 52
- Getting Help 54
- 56 Getting Started 56
- 58 Getting Started 58
- 60 Getting Started 60
- Deleting Excel Sheets 61
- Deleting Data Sheets 62
- Deleting the Query Log 62
- (Optional)” (page 48) 63
- Accessing Quick Reports 64
- Accessing Scheduled Reports 65
- Creating Custom Reports 66
- Building the Report Menu 67
- Select Systems 68
- Generating the Report 69
- Creating Custom Reports 71 71
- Controls Available by Report 72
- Report Selection 76
- Creating Custom Reports 79 79
- Select Summary Columns 81
- Max. Number 82
- Select Peak 82
- Group By 82
- Order By 83
- Time Selection 84
- Object Selection 85
- Select Cage IDs 86
- Select Disk Types 86
- Select Disk Speed 86
- Include PDs in States 86
- Select Usr CPGs 87
- Select Snp CPGs 87
- Select CPGs 87
- Select LDs 88
- Select RAID Types 88
- Select LD Usage 88
- Select LUN 88
- Select VVs 89
- Select Prov Types 89
- Select VV Types 89
- 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
- Report Information 92
- Chart Lib 92
- Chart Types 92
- • Stacked Bars 93
- • Stacked Vert Bars 93
- • Stacked Area 94
- Figure 37 Chart Using Lines 95
- Figure 38 Chart Using Bars 95
- Chart X Pixels 96
- Chart Y Pixels 96
- Time Labels 96
- Legend Position 96
- Time Format 96
- Working with Excel Charts 97
- Refreshing Charts 98
- Retaining Charts 99
- Exporting Executable Reports 100
- Customizing Excel Reports 100
- Creating a Custom Chart 101
- Saving Customized Settings 102
- 6 Interpreting Report Metrics 103
- Space Reports 106
- VV Space Reports 107
- LD Space Reports 107
- Performance Reports 108
- VV Cache Performance Reports 109
- CPU Performance Reports 110
- Link Performance Reports 110
- Adaptive Optimization Reports 111
- Configuring Sampling Policies 112
- Compacting Databases 113
- Editing Sampling Policies 114
- Adding a Storage Server 115
- Removing a Storage Server 115
- Adding an Alert Rule 117
- Changing an Alert Rule 117
- Removing an Alert Rule 118
- Alert Rule Parameters 118
- Resolution 119
- Table 57 Metric (continued) 120
- Example of an Alert Rule 121
- Scheduling Reports 122
- Adding a Scheduled Report 123
- Changing a Scheduled Report 123
- About File Permissions 124
- 8 Web Queries 126
- About Reports and Options 127
- Report Options 128
- Report Options 129 129
- &compare=LD 130
- 130 Web Queries 130
- Report Options 131 131
- &refresh=2 132
- &charttab=chart 132
- 132 Web Queries 132
- Report Options 133 133
- 134 Web Queries 134
- &alllabels=1 135
- &timeform=relative 135
- Report Options 135 135
- &begintsecs=1121277634 136
- &endtsecs=1121277634 136
- 136 Web Queries 136
- Report Options 137 137
- &groupby=System 138
- 138 Web Queries 138
- Report Options 139 139
- &orderby=System 140
- 140 Web Queries 140
- &histbegin=1 141
- Report Options 141 141
- &seldisktype=FC 145
- Report Options 145 145
- &selvv= 152
- &selvv=--All%20VVs 152
- 152 Web Queries 152
- Report Types 153
- Summary Report 153
- Options Available by Report 161
- 162 Web Queries 162
- 164 Web Queries 164
- 166 Web Queries 166
- Objects Present Reports 167
- 172 Web Queries 172
- 176 Web Queries 176
- Objects Present Reports 177 177
- 9 Using Adaptive Optimization 178
- Schedule 182
- Measurement Hours 182
- Adaptive Optimization Mode 183
- Adaptive Optimization Active 183
- VV Tiers Report 186
- The showvvcpg CLI extension 188
- 10 Database Schema 190
- The system Table 191
- The alertconfig Table 192
- The scheduled_report Table 193
- The adprovconfig Table 193
- The adprov_log Table 194
- The ldrgmoves Table 194
- The recentsample Table 195
- 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
- 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
- The statlink Table 212
- The statlinkinv Table 213
- The statldrg Table 213
- The statldrg_timeinv Table 214
- The perf_timeinv Table 214
- The space_timeinv Table 214
- 11 Troubleshooting 215
- Installation Configuration 216
- Sampling Errors 216
- Sampler Service/Daemon Errors 217
- # ./sysbck.binUsage: 218
- The [parameters] are 218
- 218 Troubleshooting 218
- Dumping the Entire Database 222
- 224 Index 224
Verwandte Produkte und Handbücher für Lager Hp 3PAR System Reporter Software
Lager Hp Secure Key Manager Bedienungsanleitung
(352 Seiten)
(352 Seiten)
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.040 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern