Hp 3PAR System Reporter Software Instrukcja Użytkownika

HP 3PAR System Reporter 3.1 MU1 SoftwareUser's GuideAbstractThis guide provides information required to install and use HP 3PAR System Reporter S

6 Configuring the System Reporter Policy Settings...115Accessing the System Reporter Policies...

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 105) shows a typical example of the metric that are provided by a Summary Report.Figure 43 S

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

Table 43 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

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

charttype...135values:...

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

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

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

QoS Performance ReportsTable 53 (page 113) describes the metric shown for QoS Performance.Table 53 QoS Performance MetricDescriptionMetricTotal (read

NOTE: Adaptive Optimization report supports reporting for only one system at a time.114 Interpreting Report metric

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

Table 55 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 48) formore instructions on setting Apache

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

selsnpcpg...147seldisktype...

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 56 Data Table (continued)DescriptionData TableRepresents the aggregation of all the FC 15K RPM PDs in the HP 3PAR StoreServ Storage.statpd_fc15s

Table 58 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

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

Space Reports...157pd_space_time...

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

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

example:...164cpu_perf_group...

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 144).GiB (2^30 bytes)See “ldspaceunit” (page 144).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

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

objectpres= porttype...179example:...

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 specifiy qos rules according to their namesvalues: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

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

The statpdinv Table...211The statld Table...

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)166 Web Queries

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

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

Figure 55 Valid Options for Performance Reports (II)Options Available by Report 169

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

Figure 56 Valid Options for Performance Reports (III)Figure 57 Valid Options for Performance Reports (IV)170 Web Queries

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

Table 59 Objects Present Report table values (continued)table valuesReportstatvlunobjects_present&“objectpres=host_name” (page 175)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

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

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

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

Selecting an HP 3PAR StoreServ Storage for Adaptive OptimizationTo begin using Adaptive Optimization on an HP 3PAR StoreServ Storage array, you must e

3. Click the Adaptive Optimization tab.The Adaptive Optimization Configuration window appears (Figure 60 (page 184)).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.

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

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

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 61 sampleinserv_5 TableCommentTypeColumnIP address of the system to sample.VARCHAR(64) NOTNULLnameDetermines whether CLI connections to the HP 3

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

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

Table 66 adprovconfig_1 Table (continued)CommentTypeColumnThe schedule for when this adaptive optimization configuration shouldbe run. The format is a

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

© Copyright 2013 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 111)Displays Node Cache

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

Table 70 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 72 ldspace_<res>_3 TableCommentTypeColumnSampl

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

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

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

Table 76 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 76 cpgspace_<res>_2 Table (continued)CommentTypeColumnThe raw free space available for the CPG.DOUBLE PRECISIONNOT NULLrawfree_mbThe usabl

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

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

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

Table 79 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 80 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 82 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 84 statport_<res>_4 Table (continued)CommentTypeColumnThe port number in the PCI slot in the node that the port is connectedto (the “p” pa

Table 86 statvlun_<res>_3 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 88 statvvcmp_<res>_2 TableCommentTypeColumnSa

Table 90 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 92 statlink_<res>_2 TableCommentType

Table 94 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.

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

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

Table 98 (continued)CommentTypeColumnLatency TypeINTEGER NOT NULLLT_TYPELatency LimitDOUBLE PRECISION NOTNULLLT_LIMITLatency TragetDOUBLE PRECISION NO

Table 98 (continued)CommentTypeColumnDifference between lt from last sample for the same objectDOUBLE PRECISION NOTNULLd_ltDelay in latencyDOUBLE PREC

Table 98 (continued)CommentTypeColumnDifference between delay_wcount value from last sample for thesame objectDOUBLE PRECISION NOTNULLd_delay_wcountDe

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

Sampler Service/Daemon ErrorsUnlike HP 3PAR StoreServ Storage sampling errors, when the sampler service or daemon(sampleloop) incurs an error, it caus

Figure 67 Microsoft Office Excel Internal ErrorIf you experience a problem with a recovered copy of the workbook (Figure 68 (page 226)), trystarting w

For oracle: hosts string. Ignored if dbtype is sqlite. -db <name> Name of the database.

From MS SQL to SQLite:sysbck -dbtype mssql -dbhost istat -db cliuser -dbpwfile dbpwfile -dbouttype sqlite -scripttype both -backupfilename "c:/te

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

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

NOTE: When executing sysbck.exe from any other directory on Windows, ensure that thePATH environment variable is set to the System Reporter root direc

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 100 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, 533PAR System Reporter.xls, 483par-policy subdirectory, 1283par-rpts subdirectory, 128Aadding a system

Red Hat Enterprise Linux, 23Region IO Density Report, 188remove a storage server from the system table, 118Remove InServ, 46Report Information control

System RequirementsHP 3PAR System Reporter supports the use of the HP 3PAR OS, versions 2.3.1, 3.1.1, and 3.1.2.Observe the minimum system hardware re

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

Figure 2 HP 3PAR StoreServ Storage and User Interface Components• Database. The HP 3PAR System Reporter database is capable of supporting SQL queries.

• Web server components. The HP 3PAR System Reporter Web server has customized scriptsthat access the database to generate reports to standard browser

NOTE: If you are upgrading an existing System Reporter installation to the 3.1 release, upgradethe CLI to version 3.1.2. You do not need to reinstall

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

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

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

the sampler or the Web server can time out. Furthermore, database compaction (see “CompactingDatabases” (page 116)) cannot be done in parallel with sa

Table 4 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.36 Installation, Config

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

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,

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

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 128) 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

a. If you selected SQLite for the database, you are prompted for the installation directoryfor the HP 3PAR Reporting Tools SQLite database. Use the Br

NOTE: In addition to configuring the SMTP parameters for alerts, it is also used for sendingan email when the If there is a problem with sampling, sen

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:

• Days to keep Daily Data -- Specifies the number of days to retain daily data.• Days to keep Adaptive Optimization Data -- Specifies the number of da

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">

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

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 52)) 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

1. Click Enable Macros to continue launching the Excel client.If you do not see the Security Warning, try completing Step 2 through Step 5 to set the

1. Click the Options button next to the security alert.The Security Alert - Macro screen appears (Figure 18 (page 57)).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

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

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

Figure 23 Quick Reports WindowAccessing Scheduled ReportsScheduled reports are generated using preselected parameters at scheduled times and are store

NOTE: If the System Reporter web application is running on a port other than 80, then you mustupdate the port number manually in the 3par-rpts/config.

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

Figure 25 Custom Reports WindowNOTE: The layout and placement of controls may vary slightly for the Excel client but operate inthe same manner as desc

Table 5 Sample ResolutionPurposeOptionChoose the Daily data table, which covers the largest time range, but has the coarsestresolution with only one s

Table 7 Select SystemPurposeOptionThe report will include all the systems that are included in the database.-All Systems-Select one or more systems to

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

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 70) 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 9 (page 73) lis

Table 9 Controls for Each ReportAdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpaceCPGSpacePD

Table 9 Controls for Each Report (continued)AdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpa

Table 9 Controls for Each Report (continued)AdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpa

Table 9 Controls for Each Report (continued)AdaptiveOptimizationQoSPerfLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpa

“Low Bucket” (page 85)“High Bucket” (page 85)“Sum End Buckets” (page 85)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

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

3 Getting Started...51Accessing the Main System Reporter Interfac

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 12 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 13 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 53)) used toselect one or more PDIDs to include i

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

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

Select Disk Speed...87Include PDs in States...

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

Table 30 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 34 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 53)) used toselect one or more QoS Rules to i

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 BarsCreating Custom Reports 95

Figure 35 Chart Using Stacked Vertical Bars• Stacked AreaFigure 36 Chart Using Stacked Areas• Lines96 Accessing and Creating Reports

Figure 37 Chart Using Lines• BarsFigure 38 Chart Using BarsCreating Custom Reports 97

• 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

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