Hp 3PAR System Reporter Software Manuel d'utilisateur Page 327
- Page / 378
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
10.35
The Sample Data and Inventory Tables
System Reporter 2.8 3PAR System Reporter User’s Guide
10.4.9.1 Calculating Common Performance Metrics
Table 10-20 shows SQL expressions that can be used to calculate various performance metrics
from the common performance columns for any sample row.
Table 10-20. Common Performance Metrics for a Sample Row
Metric SQL Expression
Read IOPs/s CASE WHEN d_now > 0 THEN d_rcount * 1000000.0/d_now ELSE 0
END
Write IOPs/s CASE WHEN d_now > 0 THEN d_wcount * 1000000.0/d_now ELSE 0
END
Total IOPs/s CASE WHEN d_now > 0 THEN (d_rcount + d_wcount) *
1000000.0/d_now ELSE 0 END
Read KBytes/sec CASE WHEN d_now > 0 THEN d_rbytes * 1000.0/d_now ELSE 0
END
Write KBytes/sec CASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0
END
Total KBytes/sec CASE WHEN d_now > 0 THEN (d_rbytes + d_wbytes)* 1000.0/
d_now ELSE 0 END
Read service time
(millisec)
CASE WHEN d_rcount > 0 THEN d_rticks / (d_rcount * 1000.0)
ELSE 0 END
Write service time
(millisec)
CASE WHEN d_wcount > 0 THEN d_wticks / (d_wcount * 1000.0)
ELSE 0 END
Total service time
(millisec)
CASE WHEN (d_rcount + d_wcount) > 0 THEN (d_rticks +
d_wticks) / ((d_rcount + d_wcount) * 1000.0) ELSE 0 END
Read IO Size
(KBytes)
CASE WHEN d_rcount > 0 THEN d_rbytes / (d_rcount * 1000.0)
ELSE 0 END
Write IO Size
(KBytes)
CASE WHEN d_wcount > 0 THEN d_wbytes / (d_wcount * 1000.0)
ELSE 0 END
- System Reporter 2.8 1
- User’s Guide 1
- Oractcl Copyright and License 3
- TWAPI Copyright & License 7
- GNU General Public License 7
- PREAMBLE 7
- NO WARRANTY 10
- Table of Contents 11
- 4 Getting Started 13
- 6 Interpreting Report Metrics 16
- 8Web Queries 17
- 9 Using Adaptive Optimization 20
- 10 Database Schema 21
- 11 Troubleshooting 22
- IX Index 23
- RH Revision History 23
- Introduction 25
- 1.3 Related Documentation 26
- 1.4 Organization 27
- 1.5 Typographical Conventions 28
- 1.6 Advisories 28
- Overview and Features 29
- Table 2-1. Available Reports 32
- 2.7 Generating Email Alerts 35
- Installation, Configuration 37
- Update, and Removal 37
- System Reporter CD Contents 38
- 0.9.8k.msi 39
- 3.3 System Requirements 40
- System Requirements 41
- System Reporter Components 45
- Installing the Web Server 49
- 3.8.1.1 SQLite 50
- 3.8.1.2 MySQL 51
- 3.8.1.3 Oracle 51
- 3.9.1 Adding InServ Systems 67
- C:\Program Files\3par\System 68
- Reporter\log\sampleloop.log) 68
- 3PAR System Reporter.xls 69
- Getting Started 75
- 4.3 Getting Help 78
- 4.4.1 Simple Selection List 79
- 4.6.1 Changing the Web Server 89
- 4.6.2 Resetting the Workbook 89
- 4.8 Deleting Excel Sheets 90
- Accessing and Creating 93
- 5.1 Accessing Quick Reports 94
- Accessing Scheduled Reports 95
- 5.3 Creating Custom Reports 96
- 5.3.1.1 Sample Resolution 98
- 5.3.1.2 Report 98
- 5.3.1.3 Select Systems 100
- 5.3.1.4 Select Domains 101
- 5.3.2 Generating the Report 102
- Creating Custom Reports 103
- Figure 5-5. Query Results 105
- 5.3.4 Report Selection 109
- 5.3.4.1 Standard Report Types 110
- Report Example 116
- Summary report 116
- 5.3.4.3 Compare 117
- 5.3.4.4 Select Peak 117
- 5.3.4.5 Group By 117
- Table 5-7. Group By 118
- Option Purpose 119
- 5.3.4.6 Order By 120
- Table 5-8. Order By 121
- 5.3.4.7 Low Bucket 122
- 5.3.4.8 High Bucket 122
- 5.3.4.9 Sum End Buckets 122
- 5.3.5 Time Selection 123
- 5.3.5.4 Count 124
- 5.3.6 Object Selection 125
- 5.3.6.3 Select Cage IDs 126
- 5.3.6.4 Select Disk Types 126
- 5.3.6.5 Select Disk Speed 127
- 5.3.6.6 Include PDs in States 127
- 5.3.6.7 Select Usr CPGs 128
- 5.3.6.8 Select Snp CPGs 129
- 5.3.6.9 Select CPGs 129
- 5.3.6.10 Select LDs 130
- 5.3.6.11 Select RAID Types 130
- 5.3.6.12 Select LD Usage 131
- 5.3.6.13 Select VVs 132
- 5.3.6.14 Select Prov Types 133
- 5.3.6.15 Select VV Types 134
- 5.3.6.16 Select Ports (n:s:p) 134
- 5.3.6.17 Select Port Types 135
- 5.3.6.18 Select Hosts 135
- 5.3.6.19 Select Nodes 136
- 5.3.6.20 Select To Nodes 136
- 5.3.6.21 Select Queues 137
- 5.3.7.1 Report Information 137
- 5.3.7.2 Chart Types 138
- Stacked Bars 139
- Stacked Vert Bars 139
- Stacked Area 140
- Vert Bars 141
- 5.3.7.3 Chart X Pixels 142
- 5.3.7.4 Chart Y Pixels 142
- 5.3.7.5 Time Labels 142
- 5.3.7.6 Legend Position 142
- 5.3.7.7 Time Format 143
- 5.3.7.8 Select Space Unit 143
- 5.4.1 Choosing a Chart Type 144
- 5.4.2 Refreshing Charts 145
- Working with Excel Charts 146
- 5.4.3 Retaining Charts 147
- =H53+J53+K53 150
- =IF(N53>0,H53/N53*100,0) 150
- Interpreting Report Metrics 153
- Summary Report 154
- 6.2 Space Reports 158
- 6.2.2 LD Space Reports 159
- 6.2.3 VV Space Reports 160
- Space Reports 161
- 6.3 Performance Reports 163
- Performance Reports 164
- 6.3.4 CPU Performance Reports 167
- Adaptive Optimization Reports 168
- Configuring the System 169
- Reporter Policy Settings 169
- Table 7-1. Sampling Policies 170
- 7.2.1 Compacting Databases 171
- Configuring Sampling Policies 172
- 7.3.1 Adding a Storage Server 175
- 7.4.1 Adding an Alert Rule 177
- 7.4.2 Changing an Alert Rule 178
- 7.4.3 Removing an Alert Rule 178
- 7.4.4 Alert Rule Parameters 179
- 7.4.4.2 Resolution 180
- 7.4.4.3 System 181
- 7.4.4.4 Metric 181
- Table 7-4. Metric 182
- 7.4.4.5 Direction 184
- 7.4.4.6 Limit Value 184
- 7.4.4.7 Limit Count 185
- 7.4.4.8 Condition 185
- 7.4.4.9 Condition Value 185
- 7.4.4.10 Recipient 185
- 7.5 Scheduling Reports 186
- Scheduling Reports 187
- 7.7 About File Permissions 190
- Web Queries 193
- <server_name>) 194
- [&<option>]) 194
- [&<option>...]) 194
- Data Format Version Report 195
- 8.4 Report Options 196
- 8.4.2 compare 197
- 8.4.2.1 values: 198
- Report Options 199
- 8.4.3 comparesel 200
- 8.4.4 table 201
- 8.4.4.2 example: 202
- 8.4.5 refresh 203
- 8.4.6 charttab 203
- 8.4.7 charttype 204
- 8.4.8 graphx 205
- 8.4.9 graphy 205
- 8.4.10 graphlegpos 206
- 8.4.11 tableformat 206
- 8.4.12 alllabels 207
- 8.4.13 timeform 208
- 8.4.14 begintsecs 208
- 8.4.15 endtsecs 209
- 8.4.16 groupby 210
- 8.4.16.2 example: 212
- 8.4.17 orderby 213
- 8.4.18 histbegin 217
- 8.4.19 ldspaceunit 217
- 8.4.20 pdspaceunit 218
- 8.4.21 vvspaceunit 219
- 8.4.22 selcageid 220
- 8.4.23 selchunks 221
- 8.4.23.2 example: 222
- 8.4.24 selcpg 223
- 8.4.25 selusrcpg 223
- 8.4.26 selsnpcpg 223
- 8.4.27 seldisktype 223
- 8.4.28 seldiskspeed 224
- 8.4.29 seldomain 225
- 8.4.30 selhost 226
- 8.4.31 selld 227
- 8.4.32 sellduse 227
- 8.4.33 selnode 228
- 8.4.34 selnsp 229
- 8.4.35 selpdid 230
- 8.4.36 selpdstate 231
- 8.4.37 selporttype 231
- 8.4.38 selraidtype 232
- 8.4.39 selsys 233
- 8.4.40 selvv 234
- 8.4.41 selvvtype 235
- 8.4.42 selprovtype 235
- 8.5 Report Types 236
- 8.6 Summary Report 237
- 8.7 Space Reports 237
- 8.7.3 ld_space_time 238
- 8.7.4 ld_space_group 238
- 8.8 Performance Reports 239
- 8.8.2 pd_perf_group 240
- 8.8.3 pd_svt_hist 240
- 8.8.4 pd_svt_histvstime 241
- 8.8.5 port_perf_time 241
- 8.8.6 port_perf_group 241
- 8.8.7 port_svt_hist 242
- 8.8.8 port_svt_histvstime 242
- 8.8.9 ld_perf_time 242
- 8.8.10 ld_perf_group 243
- 8.8.11 ld_svt_hist 243
- 8.8.12 ld_svt_histvstime 243
- 8.8.13 vlun_perf_time 244
- 8.8.14 vlun_perf_group 244
- 8.8.15 vlun_svt_hist 244
- 8.8.16 vlun_svt_histvstime 245
- 8.8.17 vv_cmp_time 245
- 8.8.18 vv_cmp_group 245
- 8.8.19 cpu_perf_time 246
- 8.8.20 cpu_perf_group 246
- 8.9.1 regiodensity 247
- 8.9.2 regmoves 247
- 8.9.3 vvtier 247
- 8.9.3.1 vvtier example 248
- Options Available by Report 249
- 8.11 Objects Present Reports 253
- Objects Present Reports 254
- 8.11.1 objectpres= cageid 257
- 8.11.2 objectpres= cpg_name 258
- 8.11.3 objectpres= diskspeed 259
- 8.11.4 objectpres= disktype 260
- 8.11.6 objectpres= host_name 261
- 8.11.7 objectpres= ld_name 262
- 8.11.8 objectpres=node 263
- 8.11.9 objectpres=pdid 264
- 8.11.10 objectpres=port 265
- 8.11.11 objectpres= system 266
- 8.11.12 objectpres= vv_name 267
- 8.11.12.2 output: 268
- 8.11.13.1 example: 268
- 8.11.13.2 output: 268
- 8.11.14 objecctpres= porttype 269
- 8.11.15 sample_times 270
- Using Adaptive 273
- Optimization 273
- Overview 274
- 9.3.2 Schedule 281
- 9.3.3 Measurement Hours 281
- 9.4.2 VV Tiers Report 288
- The showvvcpg CLI extension 290
- Database Schema 293
- 10.3 Administrative Tables 294
- 10.3.2 The sampleinserv Table 295
- 10.3.3 The system Table 296
- 10.3.4 The alertconfig Table 297
- Administrative Tables 298
- 10.3.7 The adprovconfig Table 301
- 10.3.8 The adprov_log Table 303
- 10.3.9 The ldrgmoves Table 304
- ■ hourly - Hourly samples 306
- ■ daily - Daily sample 306
- 10.4.1 The pdspace Table 307
- 10.4.2 The pdspaceinv Table 310
- 10.4.3 The ldspace Table 311
- 10.4.4 The ldspaceinv Table 313
- 10.4.5 The vvspace Table 314
- 10.4.6 The vvspaceinv Table 317
- 10.4.7 The cpgspace Table 319
- 10.4.8 The cpgspaceinv Table 321
- 10.4.10 The statpd Table 329
- 10.4.11 The statpdinv Table 331
- 10.4.12 The statld Table 332
- 10.4.13 The statldinv Table 333
- 10.4.14 The statport Table 334
- 10.4.15 The statportinv Table 335
- 10.4.16 The statvlun Table 337
- 10.4.17 The statvluninv Table 338
- 10.4.18 The statvvcmp Table 339
- 10.4.20 The statcpu Table 342
- 10.4.21 The statcpuinv Table 344
- 10.4.22 The statlink Table 344
- 10.4.23 The statlinkinv Table 346
- 10.4.24 The statldrg Table 347
- Troubleshooting 351
- 11.2.3 InServ Sampling Errors 353
- C:\Program Files\Apache 355
- Group\Apache2\logs 355
- /var/log/httpd) 355
- ■ From MySQL to Oracle: 359
- ■ From MySQL to MySQL: 359
- ■ From Oracle to MySQL: 359
- ■ From Oracle to Oracle: 359
- ■ From SQLite to SQLite: 360
- ■ From SQLite to MySQL: 360
- ■ From SQLite to Oracle: 360
- Dumping the Entire Database 362
- Revision History 371
Produits connexes et manuels pour Stockage Hp 3PAR System Reporter Software
(58 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.039 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels