Hp 3PAR System Reporter Software Manuel d'utilisateur

HP 3PAR System Reporter 3.1 MU2 SoftwareUser GuideAbstractThis guide provides information required to install and use HP 3PAR System Reporter Software

CPU Performance Reports...113Link Performance Reports..

Table 43 Time FormatPurposeOptionTime format is chosen automatically based on the sample resolution. If resolution is Daily, theformat includes the mo

Figure 40 Change Chart Type Menu for the Excel Client4. Choose the appropriate selection from the list of chart types, then select on the chart that y

1. Right-click in any data cell and click Data Range Properties in the shortcut menu that appears.Figure 41 Data Range Properties Shortcut MenuThe Ext

It is also possible to retain a chart for further reference. This can be done by moving the chart andthe data sheet linked to that chart to new worksh

NOTE: The Visual Basic code for the Excel client is password protected to prevent accidentalmodification. For customers who would like to add their ow

To create a custom chart with the Percent spare used column in Excel 2003:1. On the Dly PDSpace (1) sheet, click and drag to select the Time column (h

5 Interpreting Report metricSummary ReportFigure 43 (page 106) shows a typical example of the metric that are provided by a Summary Report.Figure 43 S

Table 45 Summary Report metric (continued)DescriptionMetricNumber of iSCSI host ports.iSCSI Host PortsNumber of disk ports.Disk PortsNumber of RCIP po

Table 45 Summary Report metric (continued)DescriptionMetricUsed PD space.Used PD Capacity GiBTotal PD space available.Total PD Capacity GiBShown by de

PD Space ReportsPD (Physical Disk) Space reports show the amount of physical disk space composed of chunkletsaccording to the usage types shown in Tab

example:...136charttab...

Table 47 CPG Space Usage Types (continued)DescriptionUsage TypeAmount of remaining Admin space available for currently allocated CPGs.Admin Space GiBA

Table 49 VV Space Report metric (continued)DescriptionMetricBeginning with the HP 3PAR OS 2.3.1 release running the updatesnapspace commandcan be sche

Table 50 Performance metric for PD, Port, LD and VLUN Performance Reports (continued)DescriptionMetricQueue length at the sample time.Queue LengthNote

Table 52 Node Cache Performance Report metric (continued)DescriptionMetricTotal number of reads. Not shown in charts.Read TotalNumber of writes for wh

QoS Performance ReportsTable 55 (page 114) describes the metric shown for QoS Performance.Table 55 QoS Performance MetricDescriptionMetricTotal (read

NOTE: Adaptive Optimization report supports reporting for only one system at a time.Adaptive Optimization Reports 115

6 Configuring the System Reporter Policy SettingsSystem Reporter enables you to edit HP 3PAR System Reporter policies, such as the samplingpolicies, a

Table 57 Sampling Policies (continued)DefaultPolicy24Default number of hours to keep Hi-Res samples (in force by default for all systemsunless specifi

} )NOTE: Please note that System Reporter does not support using Microsoft SQL with Linux systems.Editing Sampling PoliciesTo edit a System

Figure 46 Connection Dialog BoxNOTE: See “About Apache HTTP Server Authorization and Access Control” (page 51) formore instructions on setting Apache

selcpg...148value:...

1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR SystemReporter Web server scripts are installed.The 3PAR System Repor

Configuring Rules for Email AlertsSystem Reporter can be configured to evaluate numerous rules and generate email alerts to specifiedrecipients for ea

7. An alert window appears confirming that the alert rule has been changed.8. Click OK to return to the Sampling Policies window.Removing an Alert Rul

Table 58 Data Table (continued)DescriptionData TableRepresents the aggregation of all the FC 15K RPM PDs in the HP 3PAR StoreServ Storage.statpd_fc15s

Table 60 Metric (continued)Data TablesDescriptionmetricsstatpd_ssd150, statpd_sum, statpd_nl7sum,statpd_fc10sum, statpd_fc15sum,statpd_ssd150sum, stat

Limit ValueSpecifies the value that the Metric is compared to. This should be a number.Limit CountThe alert will only be generated if the number of ob

Figure 49 Scheduled Reports WindowScheduled reports offer the following advantages:• Allows quick access to pre-configured reports on a scheduled basi

5. Specify the report directory.This is the name of the directory under the top-level directory for scheduled reports (htdocs/3par/scheduledreports/).

4. Click Remove Scheduled Report.The Select Scheduled Report to Remove window appears.5. Choose the scheduled report to remove from the pull down list

The SMTP location for sending email for scheduled reports is in:/var/www/cgi-bin/3par-rpts/config.tclModifying the Apache HTTP Server Configuration Fi

Report Types...157Summary Report.

7 Web QueriesAbout Web QueriesSystem Reporter Web queries to the System Reporter Web server have the following basic format:http://<server_name>

Figure 50 System Reporter Version ReportThis query returns a 3x3 table with the column headers Category, Major, and Minor. The two rowsafter the heade

Report OptionsOptions are included in the query URL by using the following syntax:<option>=<value>where <option> and <value> a

DiskTypeCompares selected disk types. This value is only available for the pd_perf_time,ld_space_time and pd_space_time reports.DiskSpeedCompares sele

Compares selected disk magazine position. This value is only available for the pd_space_timereport.example:The following example specifies that all lo

The virtual size.tableUse the table option to specify a table from which data is returned when using one of theobjects_present reports (see “Objects P

example:The following example specifies that the report is to be reloaded every 2 minutes:&refresh=2charttabUse the charttab option to specify whe

Specifies that charts will use stacked vertical bars. Stacked charts stack data on top of each otherso you can see the total as well. See Figure 35 (p

graphlegposUse the graphlegpos option to specify the position of the chart legend. If not defined, the legendposition is selected automatically based

example:The following example specifies that all the time axis points should be labelled:&alllabels=1timeformUse the timeform option to specify a

example:...164vv_cmp_group...

If <tsecs> is non-negative it represents a point in time, expressed as the number of seconds sinceJanuary 1, 1970, GMT. For example, to express

DomainGroup results by domain.HostGroup results by hosts.CPGGroup results by Common Provisioning Group (CPG) name.UsrCPGGroup results by Common Provis

PortTypeGroup results by port type.example:The following example specifies that results should be grouped by system:&groupby=SystemThe following e

PortNodeOrder results by port node number (The n part in n:s:p).RaidTypeOrder results by RAID level (for example, RAID 0, RAID1, RAID 5 and RAID 6).LD

Order results by CPU context switches/sec.VirtSizeOrder results by VV virtual size.TotalRsvdSizeOrder results by VV reserved space size.TotalRawSizeOr

example:The following example specifies that the histogram should include all accesses:&histbegin=1ldspaceunitUse the ldspaceunit option to determ

See “ldspaceunit” (page 145).GiB (2^30 bytes)See “ldspaceunit” (page 145).examples:The following example specifies that the physical disk space unit s

value:Specify one or more of the following:--All cage IDs--(Default). Does not exclude cages based on their cage IDs.<cage_ID>This value consist

SPR_AVAIL_FAILInclude only spare available (unused) chunklets that have failed.example:The following example shows how to include chunklets regardless

seldisktypeUse the seldisktype option to select a disk type.value:Specify one or more of the following:--All Disk Types--(Default). This value does no

output:...179objectpres= vv_name_n

seldomainUse the seldomain option to select a domain according to the domain name.value:Specify one or more of the following:--ALL Domains--(Default).

The following example specifies including only VLUNs exported to host winhost1 or winhost2:&selhost=winhost1&selhost=winhost2selldUse the sell

example:The following example includes logical disks of all usage types:&sellduse=The following example specifies only logging logical disks:&

example:The following example shows two ways to specify that no ports are to be excluded based onlocation:&selnsp=OR&selnsp=--All%20Ports--The

example:The following example shows two ways to specify that physical disks are not to be excluded basedon their states:&selpdstate=OR&selpdst

Specify this value to include RAID 1 logical disks.5Specify this value to include RAID 5 logical disks.6Specify this value to include RAID 6 logical d

example:The following example shows two ways to specify that volumes be included regardless of name:&selvv=OR&selvv=--All%20VVs--The following

selqosruleUse the selqosrule option to specify qos rules according to their names.values:Specify one or more of the following:--All QosRules--(Default

Summary ReportsummaryShows summary information for all systems.example:The following example shows the entire query string for a summary report:http:/

ld_space_groupPlots the raw, used and free LD space (on y-axis) at a specific time summed over (grouped by) anycombination of several parameters.examp

Calculating Common Performance Metrics...210Service Time Histogram Buckets...

selsys=--All%20Systems--&selcpg=--All%20CPGs--&selvv=--All%20VVs--&report=vv_space_timevv_space_groupPlots the virtual size as well as the

pd_svt_histPlots the service time histogram of all the physical disks in the selected systems at a specific time.example:The following example shows t

port_svt_histPlots the service time histogram of all the ports in the selected systems at a specific time.example:The following example shows the enti

ld_svt_histPlots the service time histogram of all the logical disks in the selected systems at a specific time.example:The following example shows th

vlun_svt_histPlots the service time histogram of all the VLUNs (exports) in the selected systems at a specific time.example:The following example show

example:The following example shows the entire query string for a cpu_perf_time report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?charttab=cha

regiondensity exampleThe following example shows the entire query string for a regiodensity report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?

Figure 51 Valid Options for Summary, Space and Adaptive Optimization Reports (I)Options Available by Report 167

Figure 52 Valid Options for Summary, Space and Adaptive Optimization Reports (II)168 Web Queries

Figure 53 Valid Options for Summary, Space and Adaptive Optimization Reports (III)Figure 54 Valid Options for Performance Reports (I)Options Available

1 Overview and FeaturesThis document provides the information you need to install and use HP 3PAR System Reporter tomonitor performance, create charge

Figure 55 Valid Options for Performance Reports (II)170 Web Queries

Figure 56 Valid Options for Performance Reports (III)Figure 57 Valid Options for Performance Reports (IV)Options Available by Report 171

Objects Present ReportsObjects present reports return the objects present in a table over a specified time for use in userinterface controls. For exam

Table 61 Objects Present Report table values (continued)table valuesReportstatvlunobjects_present&“objectpres=host_name” (page 176)ldspacestatldob

objectpres= cpg_nameReturns a list of common provisioning group (CPG) names.example:The following example shows the entire query string for:objects_pr

objects_present&objectpres=diskspeedhttp://localhost/cgi-bin/3par-rpts/inserv_perf.exe?report=objects_present&objectpres=diskspeed&table=s

output:Returns a row for each domain present over the time range on each system.Output columns are:• System: the system name• Domain: domain namesobje

output:Returns a row for each logical disk present over the time range for each system.Output columns are:• System: the system name• LD: logical disk

example:The following example shows the entire query string for:objects_present&objectpres=pdid:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe

objectpres= systemReturns a list of storage systems.example:The following example shows the entire query string forobjects_present&objectpres=syst

• Scheduling of reports with predefined parameters that are initiated at predetermined timesand can then be accessed when needed.• Customization of re

Output columns are:• System: system name• VV: virtual volume namesThe following is example output of the query:objectpres= vv_name_nosnapReturns a lis

example:The following example shows the entire query string for:objects_present&objectpres=porttypehttp://localhost/cgi-bin/3par-rpts/inserv_perf.

Objects in statqosinv_hires_1, system_4qos_set3'SRV400vvset0.1'SRV400vvset0.2'SRV400vvset0.3'SRV400sample_timesReturns valid times

8 Using Adaptive OptimizationIf you have an Adaptive Optimization license, you can use the Adaptive Optimization feature inconjunction with System Rep

System Reporter can generate a number of different reports that you can use to track storageutilization and monitor the movement of data performed by

3. Click the Adaptive Optimization tab.The Adaptive Optimization Configuration window appears (Figure 60 (page 185)).Figure 60 Adaptive Optimization C

NOTE: When you specify two tiers, for the purposes of analysis and data movement only theorder of the tiers matters, not the actual tier number. For e

except in the case where the CPG is the default for snapshot or base TPVV allocation as noted inthe following caution.CAUTION: For some CPGs, especial

not be optimal. We can achieve optimal results by scheduling adaptive optimization execution for11 am Monday through Friday with a measurement interva

9. Choose whether the configuration is to be currently active (true/false). This switch allows youto turn the optimization off and on as required.10.

Quick Reports -- Allows you to immediate access a variety of predefined reports (created throughCGI programs) that are deemed useful for most installa

Figure 61 Region IO Density Showing Total SpaceFigure 62 Region IO Density Showing Total IO AccessEach region is put into the appropriate histogram bu

Figure 63 Region IO Density without Adaptive OptimizationYou can see that much of the space is used for regions with very few IO accesses and that mos

Figure 65 VV Tiers ReportAdaptive Optimization Space Moved ReportThe Space Moved report shows the space moved over a selected time interval for each A

report shows the space moved over the selected time interval for each Adaptive Optimizationconfiguration.The showvvcpg CLI extensionAdaptive Optimizat

esx-sysrpt esx-fc-r1 384 - 112128 - - -esx-sysrpt esx-ssd-r1 128 - 7680 - - -esx-sqa esx-fc-r1 384 - 44544 - - -esx-sqa esx-ssd-r1 128 - 1536 - - -esx

9 Database SchemaUsing The Database SchemaThe description of the database schema is provided as a convenience to those wishing to querythe database di

Table 63 sampleinserv_5 TableCommentTypeColumnIP address of the system to sample.VARCHAR(64) NOTNULLnameDetermines whether CLI connections to the HP 3

Table 64 system_4 Table (continued)CommentTypeColumnSystem hardware model, for example:VARCHAR(32) NOTNULLsystem_modelInServ S400XInServ T400Indicates

Table 66 scheduled_report_2 TableCommentTypeColumnA unique identifier for each scheduled report.INTEGER PRIMARY KEY(AUTO_INCREMENT)rpt_idThe top level

Table 68 adprovconfig_1 Table (continued)CommentTypeColumnMaximum size of the storage space that can be used for the T0 tierINTEGER NOT NULLT0_GBMaxim

© Copyright 2014 Hewlett-Packard Development Company, L.P.The information contained herein is subject to change without notice. The only warranties fo

Table 1 Available Reports (continued)Report Metrics Cross ReferenceDescriptionReport Name“Node Cache Performance Reports”(page 112)Displays Node Cache

Table 70 ldrgmoves_1 TableCommentTypeColumnTime in secs when the LD region move was scheduled. This is theUnix time and is the number of seconds since

Table 71 recentsample_1 TableCommentTypeColumnThe sample resolution, one of hires, hourly or daily.VARCHAR(32) NOT NULLresolutionSample time in secs o

Table 72 pdspace_<res>_3 Table (continued)CommentTypeColumnNumber of normal chunklets that were used in LDs but havefailed.INTEGER NOT NULLNRM_U

The ldspace TableThe ldspace_<res>_3 table holds logical disk (LD) space data samples.Table 74 ldspace_<res>_3 TableCommentTypeColumnSampl

Table 75 ldspaceinv_<res>_3 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number of secondssince 0:00:00 Jan 1, 19

Table 76 vvspace_<res>_4 Table (continued)CommentTypeColumnThe provisioning type of the VV (see the Prov column for the showvv CLIcommand in HP

Table 76 vvspace_<res>_4 Table (continued)CommentTypeColumnRaw (physical space including RAID overhead) user space reserved for theVV in MB.DOUB

Table 78 cpgspace_<res>_2 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number of secondssince 0:00:00 Jan 1, 1970

Table 78 cpgspace_<res>_2 Table (continued)CommentTypeColumnThe raw free space available for the CPG.DOUBLE PRECISIONNOT NULLrawfree_mbThe usabl

Table 80 Common Performance Columns (continued)CommentTypeColumnDifference between qlen value from last sample for the same object.DOUBLE PRECISIONNOT

Formatting Reports for PresentationWhen building customized reports, you can specify how the reporting data is formatted for viewingby selecting the a

Table 80 Common Performance Columns (continued)CommentTypeColumnNumber of reads in service time bucket number 0.DOUBLE PRECISIONNOT NULLrhist0Differen

Table 81 Common Performance Metrics for a Sample RowSQL ExpressionMetricCASE WHEN d_now > 0 THEN d_rcount * 1000000.0/d_now ELSE 0 ENDRead IOPs/sCA

Table 82 statpd_<res>_4 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number of secondssince 0:00:00 Jan 1, 1970 G

Table 84 statld_<res>_5 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number of secondssince 0:00:00 Jan 1, 1970 G

Table 86 statport_<res>_4 Table (continued)CommentTypeColumnThe port number in the PCI slot in the node that the port is connectedto (the “p” pa

Table 88 statvlun_<res>_4 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number ofseconds since 0:00:00 Jan 1, 1970

The statvvcmp TableThe statvvcmp_<res>_2 table holds VV cache performance data samples.Table 90 statvvcmp_<res>_2 TableCommentTypeColumnSa

Table 92 statcpu_<res>_1 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number ofseconds since 0:00:00 Jan 1, 1970

The statlink TableThe statlink_<res>_2 table holds the inter-node link performance data samples.Table 94 statlink_<res>_2 TableCommentType

Table 96 statldrg_hourly_2 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number ofseconds since 0:00:00 Jan 1, 1970 GMT.

Using the Database Schema to Build Custom ReportsThe databases used by System Reporter are standard relational databases capable of supportingSQL quer

Table 99 space_timeinv_<res>_1 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number ofseconds since 0:00:00 Jan 1,

Table 100 statqos_<res>_1 Table (continued)CommentTypeColumnLatency TypeINTEGER NOT NULLlt_typeLatency LimitDOUBLE PRECISION NOTNULLlt_limitLate

Table 100 statqos_<res>_1 Table (continued)CommentTypeColumnDifference between lt from last sample for the same object.DOUBLE PRECISION NOTNULLd

Table 100 statqos_<res>_1 Table (continued)CommentTypeColumnDifference between delay_wcount value from last sample for thesame object.DOUBLE PRE

10 Troubleshooting System ReporterTroubleshooting OverviewThe first step when troubleshooting System Reporter is to identify the component that is cau

Installation ConfigurationOn Windows, you can see the parameters with which the sampler was installed by typing thefollowing command in that directory

Errors incurred by the CLI sampler process.Errors incurred by the CLI sampler process may include loss of network connectivity to the HP 3PARStoreServ

to medium or low (see “Setting the Security Level for Excel” (page 58)) and reopen theworkbook.• If you see a warning containing "internal state

NOTE: The sysbck command is recommended when extracting a relatively small sampling ofthe database. The command creates a file with SQL statements to

NOTE: The -dbouttype parameter is optional; by default, the extract database is MySQL.• From MySQL to Oracle:sysbck -dbtype mysql -dbhost istat -db cl

2 Installation, Configuration, Update, and RemovalBefore You BeginBefore installing HP 3PAR System Reporter components, select a system on which to ru

• From SQLite to SQLite:sysbck -dbtype sqlite -db cliuser -dbouttype sqlite -scripttype both -backupfilename "c:/test/test_20100713_1322PM"

• Issuing sysbck without a begin and end date (this will extract for all data for system s138):sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfi

Dumping the Entire MySQL DatabaseTo create a dump of a MySQL database use the mysqldump program as follows# mysqldump --host=hostname --user=username

11 Support and Other ResourcesContacting HPFor worldwide technical support information, see the HP support website:http://www.hp.com/supportBefore con

See:For information about:HP 3PAR-to-3PAR Storage Peer Motion GuideMigrating data from one HP 3PAR storage system to anotherHP 3PAR Secure Service Cus

See:For information about:Planning for HP 3PAR storage system setupHardware specifications, installation considerations, power requirements, networkin

Typographic conventionsTable 102 Document conventionsElementConventionBold text• Keys that you press• Text you typed into a GUI element, such as a tex

12 Documentation feedbackHP is committed to providing documentation that meets your needs. To help us improve thedocumentation, send any errors, sugge

IndexSymbols3PAR System Reporter User’s Guide, 563PAR System Reporter.xls, 513par-policy subdirectory, 1293par-rpts subdirectory, 129Aadding a system

Red Hat Enterprise Linux, 23Region IO Density Report, 189remove a storage server from the system table, 119Remove InServ, 48Report Information control

System RequirementsHP 3PAR System Reporter supports HP 3PAR OS v2.3.1, v3.1.1, v3.1.2, and v3.1.3 versions.Observe the minimum system hardware require

Using the System Reporter Sizing SpreadsheetBefore installing System Reporter, you need to determine the system resources that are required toadequate

Figure 1 System Reporter Sizing Spreadsheet1. Click the appropriate type of database that you are using for System Reporter at your site.You will noti

Storage System Components and Recommended High Resolution Sampling IntervalTable 4 (page 27) gives an overview of the storage system components, examp

• Manage only one storage system in one instance of System Reporter when a storage systemhas more than 32000 VLUNs.• Update the max_allowed_packet par

supports limited concurrency, these functions are performed by the sampleloop process).These include:– The trimdb process removes samples that are old

TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION1. Definitions."License" shall mean the terms and conditions for use, reproducti

Optional ComponentsInstallation of the following components are optional:• Excel client (optional). While the necessary Excel sheet is automatically i

Figure 3 Installation Process FlowchartInstalling the Web ServerHP 3PAR System Reporter requires Apache HTTP Server, version 2.2 or later.A copy of th

NOTE: System Reporter 2.9 and beyond supports secure connections on Apache servers usingthe SSL protocol. For details on implementing the SSL protocol

installation or configuration, it is very simple to use but it has several limitations that make it onlysuitable for small database sizes and limited

Table 6 Database Comparison (continued)OracleMySQLMicrosoft SQLSQLiteCommentYesYesYesNo, recommendless than 1 GBScale to large databasesize?YesYesYesN

Figure 4 Selecting Data Sources (ODBC)On the System Reporter host create a System ODBC DSN as follows:1. Select Administrative Tools→Data Sources (ODB

Figure 6 Selecting the data source for the SQL driver4. Choose SQL Server Native Client 10.0. Any SQL server ODBC driver will work. However, theSQL Se

6. Click Next.Figure 8 Entering the Login ID and Password7. Enter the user's log in and password information, then click Next.Figure 9 Specifying

9. Click Next.Figure 10 Checking the Details for the Database10. Click Finish.Figure 11 ODBC Microsoft SQL Server Setup Screen.38 Installation, Config

11. Check the details for the selected database, then click Test Data Source.The screen must show the following (Figure 12 (page 39)):Figure 12 SQL Se

modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendumto the NOTICE tex

6. Make sure that Configure MySQL Server now is checked and then click Finish.The MySQL Server Instance ConfigurationWizard appears.NOTE: When install

Setting the max_allowed_packet parameterChange the max_allowed_packet MySQL parameter by editing its value in the MySQL initializationfile.• On Linux,

4. Grant the two users the privilege levels described above by running the commands below:use inservstatsgrant all on * to cliuser;grant select on * t

user names and passwords for the cliuser and the webuser. See “Modifying the Apache HTTPServer Configuration Files” (page 129) for instructions on edi

Installing or Upgrading the System Reporter ToolsYou have several options for installing the HP 3PAR System Reporter tools, depending on whetheryou ch

5. Use the Browse... button to select and enter the installation directory for the HP 3PAR SystemReporting Tools sampler or accept the default directo

configure System Reporter to generate email alerts, you must enter the IP address or name ofthe SMTP server, the user name and password if the SMTP se

Installing System Reporter Tools on LinuxSystem Reporter tools on Linux consists of two RPM packages available on the CD:• sampleloop (sampleloop-3.1-

6. Install the sysrptwebsrv package by mounting the System Reporter CD, changing to the directoryon the CD that includes the rpm packages and running:

Click OK or Cancel.• If you click Cancel, then addition of InServ fails and the certificate is not stored.• If you click OK, then the InServ gets adde

To protect your rights, we need to make restrictions that forbid anyone to deny you these rights or to ask you to surrender the rights. These restrict

11. Repeat step 5 to add additional storage servers and then click Return to Policies.NOTE: The maximum CPG size supported when region data sampling i

The HP 3PAR System Reporter Excel client is contained in a single Microsoft Excel workbook withthe file name 3PAR System Reporter.xls. After downloadi

file, you must also create a password file {password_file}, as described in your Apachedocumentation.<Directory "cgi-bin/3par-rpts">

7. Locate and remove the inservstats.db file if the file was in a location other than theSystem Reporter folder. Also remove the file inservstats.db-j

3 Getting StartedYou can use HP 3PAR System Reporter from the primary web interface or an Excel client.NOTE: For information on using a Web browser to

Figure 14 The System Reporter Main WindowThe HP 3PAR System Reporter Main Menu (Figure 14 (page 55)) is divided into the followingareas:• Title Pane,

◦ User Guide (this document in PDF format).◦ Sampling Status (the time since the most recent high-resolution sample for each systembeing sampled).NOTE

The list of available objects can be filtered by typing an expression pattern in the text input areaabove the list of available objects and clicking o

Figure 15 System Reporter Excel ClientSetting the Security Level for ExcelThe HP 3PAR System Reporter Excel client uses macro code to implement its fu

2. On the Microsoft Excel Tools menu, point to Macro, then Security.The Security dialog box appears with the Security Level tab enabled (Figure 17 (pa

Accompany it with the information you received as to the offer to distribute corresponding source code. (This alternative is allowed only fornoncommer

1. Click the Options button next to the security alert.The Security Alert - Macro screen appears (Figure 18 (page 60)).Figure 18 Macro Security Alert

Figure 19 Trust Center Screen8. If it is not already set, from the list of Macro Settings, choose Disable all macros withnotification.NOTE: The HP 3PA

1. After opening the HP 3PAR System Reporter Excel client workbook with the correct securitylevel setting, click Initialize.The Connection Parameters

Changing the Excel Client Server and Resetting the WorkbookThe HP 3PAR System Reporter Excel client workbook includes a custom 3PAR menu that is acces

Deleting Data SheetsData sheets remain until you manually delete them. Manually deleting a data sheet causes anyembedded charts associated with that d

Figure 22 Security Alerts Multiple IssuesTo enable macros and the data connection, choose the Enable this content buttons.NOTE: If it is ever necessar

4 Accessing and Creating ReportsSystem Reporter provides quick reports, scheduled reports, and custom reports that are specificallytailored for your o

Accessing Scheduled ReportsScheduled reports are generated using preselected parameters at scheduled times and are storedin subdirectories whose struc

Creating Custom ReportsYou can create customized reports by selecting the Custom Reports tab from the Main Menu or bychoosing the Excel Client from th

“Report ” (page 69)“Select Systems” (page 70)“Select Domains” (page 70)“Format Selection (Web interface only)” (page 94)Sample ResolutionThe Sample re

Contents1 Overview and Features...17User Interfaces...

Table 8 Reports and Uses (continued)PurposeReportsDisplay CPU performance. See “CPU Performance Reports” (page 113) for the types of statisticsprovide

Figure 26 Report Menu for Daily VLUN PerformanceThe top of the report menu includes a section that lists the current selection of systems of domains.I

Use the controls in the menu to select the desired report parameters and then click Generate Report.See Figure 26 (page 71) for a listing of the contr

Figure 27 Query ResultsIf necessary, use the scrollbox on the right to view all charts and/or tables.Controls Available by ReportTable 11 (page 74) li

Table 11 Controls for Each ReportAdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpaceCPGSpaceP

Table 11 Controls for Each Report (continued)AdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSp

Table 11 Controls for Each Report (continued)AdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSp

Table 11 Controls for Each Report (continued)AdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSp

“Low Bucket” (page 86)“High Bucket” (page 86)“Sum End Buckets” (page 86)Standard Report TypesThe following standard report types are available (Table

Figure 28 Versus Time Report ExampleIn the aggregate performance of all the selected objects (possibly in multiple systems) is shown.Typically, some c

Removing the System Reporter Components...52Removing the System Reporter

Figure 29 Versus Time with Compare=System Report ExampleIf you want to compare the performance of a particular class of objects (for example, systems)

Figure 30 Group By System:Host At Time Report ExampleThe At Time report can be used in conjunction with the Group By and Order By controls to do mored

Figure 31 Histogram Versus Time Report ExampleThe Histogram Versus Time report provides a histogram or service times for the aggregate of theselected

Figure 32 Histogram At Time Report ExampleThe Histogram At Time report provides a histogram or service times and IO sizes at a specific timefor the ag

Max. NumberSpecifies the maximum number of graphs that will be generated for a given report. This option isonly valid when a compare is requested and

Order ByThis control is only valid for At Time reports and specifies the order of the X (category) axis for thereports. The menu options available dep

Table 14 Order By (continued)PurposeOptionOrder by queue length.Queue LengthOrder by the percentage of time that the VLUN is busy (i.e., has at least

Table 15 Begin/At TimePurposeOptionBegin with the earliest sample available.earliestBegin at the specified time value. The values in the menu are popu

Select PDIDsThis is a filtered multi-selection control (see “Filtered Multi-Selection Control” (page 56)) used toselect one or more PDIDs to include i

Table 22 Select Disk SpeedPurposeOptionThe report will include all the Disk Speeds that are included in the database.-All Disk Speeds-Select one or mo

Select PDIDs...88Include Chunklets...

Table 25 Select Snp CPGsPurposeOptionThe report will include all the Snp CPGs that are included in the database.-All CPGs-Select one or more Snp CPGs

Table 29 Select LD Usage (continued)PurposeOptionInclude LDs mapped to VV snapshot copy admin space.C,SA: Copy Snapshot AdminInclude LDs that are mark

Table 32 Select Prov Types (continued)PurposeOption• tpsd - Old-style thin provisioned VV (created with an older release than 2.3.1)where both the bas

Table 36 Select Ports (n:s:p)PurposeOptionThe report will include all the Ports that are included in the database.-All Ports-Select one or more ports

Select QoS RulesThis is a filtered multi-selection control (see “Filtered Multi-Selection Control” (page 56)) that is usedto select one or more QoS Ru

Figure 33 Example of a TableChart LibAllows you to optionally select the charting package used by System Reporter. By default, the(Static) charting ca

You can choose from the following chart types:• Stacked BarsFigure 34 Chart Using Stacked Bars• Stacked Vert Bars96 Accessing and Creating Reports

Figure 35 Chart Using Stacked Vertical Bars• Stacked AreaFigure 36 Chart Using Stacked Areas• LinesCreating Custom Reports 97

Figure 37 Chart Using Lines• BarsFigure 38 Chart Using Bars98 Accessing and Creating Reports

• Vert BarsFigure 39 Chart Using Vert BarsChart X PixelsYou can explicitly specify the length in pixels of the X (category) axis of charts. If this is