HP 3PAR StoreServ 7400 2-node HP 3PAR System Reporter 3.1.0 Software User&
HP 3PAR StoreServ 7400 2-node Manual
View all HP 3PAR StoreServ 7400 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
HP 3PAR StoreServ 7400 2-node manual content summary:
- HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 1
HP 3PAR System Reporter 3.1 Software User's Guide Abstract This guide provides information required to install and use HP 3PAR System Reporter Software to monitor performance, create charge back reports, and plan storage resources for HP 3PAR StoreServ Storage systems, and is intended for system and - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 2
to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 3
work (an example is provided in the Appendix below). "Derivative Works" shall mean any work, whether in Source or Object form, that is based on (or derived from) the Work and for which the editorial revisions, annotations, elaborations, or other modifications represent, as a whole, an original work - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 4
may choose to offer, and charge a fee for, acceptance of support, warranty, indemnity, or other liability obligations and/or rights consistent with you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 5
to know that what they have is not the original, so that any problems introduced by others will not reflect on the original authors' reputations. Finally, you distribute the same sections as part of a whole which is a work based on the Program, the distribution of the whole must be on the terms of - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 6
modifying or distributing the Program (or any work based on the Program), you indicate your acceptance of , but may differ in detail to address new problems or concerns. Each version is given a distinguishing version exceptions for this. Our decision will be guided by the two goals of preserving the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 7
the Database Schema to Build Custom Reports 22 Analyzing and Optimizing Storage Utilization 22 2 Installation, Configuration, Update, and Removal 23 the Oracle Users for System Reporter 40 Creating the Oracle Net Service 41 Installing or Upgrading the System Reporter Tools 42 Installing or - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 8
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 9
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 10
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 11
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 12
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 13
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 14
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 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 15
Optimization 180 Overview...180 Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization 181 Configuring Adaptive Optimization Common Performance Table Columns 205 Calculating Common Performance Metrics 207 Service Time Histogram Buckets 208 IO Size Histogram Buckets 208 The statpd - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 16
Sampler Service/Daemon Errors 219 Troubleshooting Adaptive Optimization Components 219 Troubleshooting the Web Server Components 219 Troubleshooting 224 11 Support and Other Resources 225 Contacting HP...225 HP 3PAR documentation...225 Typographic conventions...228 HP 3PAR branding information - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 17
use the system reporting tools described in this guide. Two user interfaces are offered as part of the HP 3PAR StoreServ Storage: a Web-based interface and an Excel client. • The Web-based interface enables you to monitor HP 3PAR StoreServ Storage systems and access statistics using a standard Web - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 18
) file formatting standard for inclusion in web or Excel applications. • Support for creating custom web or Excel reports using well documented Web queries. compaction, etc. • InServ Systems -- Selects the HP 3PAR StoreServ Storage systems to include for sampling, report generation and optional - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 19
of the most active physical disks for a given system. Scheduled Reports -- Allows you to view reports that were created at scheduled times based on preselected parameters and stored in a reserved directory structure. You can either view the reports via the web interface provided through System - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 20
between nodes. Adaptive page 113)). The data is purged based on the limit set through the retention period for individual systems (see "Adding Storage Systems" (page 46) for details). service times and IO sizes at a specific point in time. ◦ Histogram vs Time reports show the distribution of service - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 21
time format and specifying how the units of storage measurement are represented (i.e., MBs, TBs, chunklets, option, you must use a browser that supports html5 canvas tags (the latest versions of an email alert when any VLUN has an average read service time of more than 100 ms in any high-resolution - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 22
The databases used by System Reporter are standard relational databases capable of supporting SQL queries. The default (built-in) database is SQLite (see http "Database Schema" (page 192). Analyzing and Optimizing Storage Utilization For HP 3PAR OS 3.1.1 or OS 2.3.1, an optionally licensed component - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 23
at: Document/CLI\3.1.2_CLI_Administrator_Manual.pdf, for instructions on installing the HP 3PAR OS CLI. System Reporter CD Contents The HP 3PAR StoreServ Storage CD includes the following contents (Table 2 (page 23)): Table 2 HP 3PAR StoreServ Storage CD Contents Directory Filename Description - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 24
components have the following requirements (Table 4 (page 24): Table 4 HP 3PAR StoreServ Storage Requirements Component Supported Operating Systems Additional Requirements Database Microsoft SQL Server Sampling service Windows Server 2008 and Windows MySQL Database Server version 5.1 Server - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 25
Reporter and the selected data base server. The optimal computing power (CPU cores), memory and storage space needed to accommodate the Reporter at your site. You will notice that SQlite only supports one HP 3PAR StoreServ Storage for use with System Reporter. Please consider another database - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 26
includes the following components (Figure 2 (page 26)): Figure 2 HP 3PAR StoreServ Storage and User Interface Components • Database. The HP 3PAR System Reporter database is capable of supporting SQL queries. Four types of databases are supported: Microsoft SQL Server, SQLite, MySQL and Oracle (see - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 27
supports limited concurrency, these functions are performed by the sampleloop process). These include: - creates a regionmover process for each HP 3PAR StoreServ Storage array for which Adaptive Optimization is configured (see "Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization" (page - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 28
respective vendor. • Adaptive Optimization (Offered by HP as an option; requires a separate license for HP 3PAR OS 2.3.1 and 3.1.1 only.) NOTE: If table updates are logged in the sampleloop.log. Contact your customer service representative if any tables fail to update properly. The following - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 29
requires Apache HTTP Server, version 2.2 or later. A copy of the installer executable for Windows of Apache HTTP Server, version 2.2, is located on the HP 3PAR System Reporter CD or you can download the most recent version from www.apache.org. Red Hat Linux typically includes the Apache Web Server - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 30
following file: /etc/httpd/conf/httpd.conf Installing the Database Server System Reporter supports several database servers: Microsoft SQL, SQLite, MySQL and Oracle. Before beginning the installation, select the database based on the considerations described below and summarized in Table 5 (page 31 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 31
a comparison of features for the various database choices. Table 5 Database Comparison Comment Included with System Reporter? Sample more than one HP 3PAR StoreServ Storage? Supports Adaptive Optimization? Can have remote database server? SQLite Yes No No No Microsoft SQL No Yes Yes Yes MySQL No - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 32
and an index filegroup. Also, because SQL Server works with 8 k pages, each filegroup consists ideally of multiple small files. For example, for a 10 GB database, HP recommends that you create five files of 2 GB each for the data filegroup, and that you create files of about the same size for the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 33
Figure 4 Selecting Data Sources (ODBC) On the System Reporter host create a System ODBC DSN as follows: 1. Select Administrative Tools→Data Sources (ODBC). The ODBC Data Source Administrator screen appears: Figure 5 ODBC Data Source Administrator Screen 2. Select the System DSN tab. 3. Click Add. - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 34
Figure 6 Selecting the data source for the SQL driver 4. Choose SQL Server Native Client 10.0. Any SQL server ODBC driver will work. However, the SQL Server Native Client ODBC is supplied with the Microsoft SQL Server client and is considered to be the most efficient. NOTE: Although you have the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 35
6. Click Next. Figure 8 Entering the Login ID and Password 7. Enter the user's log in and password information, then click Next. Figure 9 Specifying the MSSQL Database Name 8. Check the Change the default database check box, and enter the name of the MSSQL database that has been created for System - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 36
9. Click Next. Figure 10 Checking the Details for the Database 10. Click Finish. Figure 11 ODBC Microsoft SQL Server Setup Screen. 36 Installation, Configuration, Update, and Removal - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 37
must install MySQL Database Server, version 5.1, following the instructions provided in this section. MySQL Database Server is optional third-party software and is not provided by HP. Installing MySQL Server To use MySQL for the HP 3PAR System Reporter database, obtain a software license and a copy - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 38
following and then click Next: • Install As Windows Service is selected • the default Service Name is MySQL • the Launch the MySQL Server System Reporter only supports and creates MyISAM tables. Conversion of these tables to use any other type of storage engine is not supported. 38 Installation, - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 39
server. • On Windows you can do this by restarting the MySQL service. • On Linux, you can run: /etc/init.d/mysqld restart CAUTION See "Modifying the Apache HTTP Server Configuration Files" (page 125) for instructions on editing these config.tcl files if you change the MySQL usernames and passwords - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 40
instructions provided in this section. To use and install MySQL go to "Installing and Setting Up the Microsoft SQL Server Database (Optional)" (page 32). Oracle is optional third-party software and is not provided by HP. Installing the Oracle database server is beyond the scope of this guide storage - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 41
and click OK. The test should succeed. Click Next. 9. Enter a net service name. This is the name you will need to enter when installing the System Reporter tools. Click Next. 10. Follow instructions to complete the net service configuration and exit the program. Installing the Database Server 41 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 42
terminating a compactdb prematurely causes problems with the database for MySQL select and enter the full path to the HP 3PAR OS CLI executable cli.exe (if it is 3PAR/System Reporter) and then click Next. 6. Make sure that the desired database is selected, then click Next. 7. This step differs based - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 43
are prompted for the host string. Enter the net service name you entered in step 9 "Creating the Oracle Net Service" (page 41) and click Next. NOTE: If the installation directory for the HP 3PAR System Reporting Tools sampler (default file path C:/Program Files/3PAR/System Reporter/dbpwfile). See " - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 44
"Troubleshooting the Sampling Components" (page 217)). 10. Click Next and then, when prompted, click Finish. The HP 3PAR System Reporter Installer window closes. 11. On the Windows Control Panel, open Administrative Tools and then Services. 12. In the Services window, locate the entry for HP 3PAR - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 45
Installing System Reporter Tools on Linux System Reporter tools on Linux consists of two RPM packages available on the CD: • sampleloop (sampleloop-3.1-1.i386rpm) consists of the files needed to install the sampleloop daemon. • sysrptwebsrv (sysrptwebsrv-3.1-1.i386.rpm) consists of the files needed - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 46
of the server where Apache and System Reporter are installed. Adding Storage Systems Follow these instructions for adding HP 3PAR StoreServ Storage systems to be sampled. 1. Open a Web browser and point it at http:///3par/ where is the Web server where Apache HTTP Server is - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 47
Storage Server Sampling" (page 117). 11. Repeat step 5 to add additional storage servers and then click Return to Policies. NOTE: The maximum CPG size supported ) (hires, space=0) (9 secs) You can now return to the HP 3PAR System Reporter window and execute database queries using a Web browser. NOTE: - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 48
see "Accessing the Optional Excel Client" (page 54) for further instructions. About Apache HTTP Server Authorization and Access Control You can configure Apache username and password before allowing a user to: • read the HP 3PAR System Reporter database or view the database sampling policies. • make - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 49
and then click Stop. Close the Services window. 3. From a command prompt, change to the directory where you installed the HP 3PAR System Reporter tools: # cd \program files\3par\system reporter 4. Execute the following command: # winserv uninstall "3PAR System Reporter sampler" 5. Exit and close - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 50
present in the same directory. Removing the MySQL Database (Optional) If you are using a MySQL database and you want to completely remove all HP 3PAR System Reporter components, you should also remove the inservstats database using the MySQL Administrator, as described in this section. 1. Log in to - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 51
HP 3PAR System Reporter from the primary web interface or an Excel client. NOTE: For information on using a Web browser to edit database sampling policies, add or remove storage servers from the database, schedule reports or optimize storage page 48) for more instructions on setting Apache HTTP - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 52
details on configuring policy settings). The following tabs are provided from the policy settings window: - Add Systems -- used to specify the HP 3PAR StoreServ Storage systems for reporting purposes. - Alert Rules -- used to specify the alert rules. - Schedule Report -- used to schedule reports at - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 53
menu items to access the appropriate section of the User Guide that provides help. NOTE: Adobe Acrobat® is required to view the HP 3PAR System Reporter Software User's Guide. See www.adobe.com/support/downloads for download instructions. Using the Object Selection Controls Menus in System Reporter - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 54
Excel. Accessing the Optional Excel Client The HP 3PAR System Reporter Excel client is supported on Microsoft Windows systems for creating and Optional)" (page 47) for instructions on saving the 3PAR System Reporter.xls file on your local machine. The HP 3PAR System Reporter Excel client opens - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 55
Figure 15 System Reporter Excel Client Setting the Security Level for Excel The HP 3PAR System Reporter Excel client uses macro code to implement its functionality. In order for this code to be executed, you must set the proper security - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 56
the Security Level tab, set the security level to Medium or Low (Medium is the default and suggested setting) and then click OK. NOTE: The HP 3PAR System Reporter Excel client will not work if the Microsoft Excel security level is set to High or Very High. 4. If you changed the security - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 57
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 for Excel 2007 2. Choose the Enable this content radio button. 3. Click OK. If you do not see a Security Warning when accessing the Excel client, it - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 58
19 Trust Center Screen 8. If it is not already set, from the list of Macro Settings, choose Disable all macros with notification. NOTE: The HP 3PAR System Reporter Excel client will not work if the Macro Setting is set to Disable all macros without notification or Disable all macros except digitally - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 59
name is the name of the Web server where the Apache HTTP Server and HP 3PAR System Reporter Web server scripts are installed (see "Before You Begin" (page Type your user name and password and click OK. NOTE: For more instructions on setting Apache HTTP Server to require a username and password, see - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 60
how to delete the query log and other sheets. Deleting Excel Sheets When using the HP 3PAR System Reporter Excel client, you can reset the entire workbook to its original state by following the instructions in "Resetting the Workbook" (page 60), or you can delete unwanted sheets individually as - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 61
until you manually delete them. Manually deleting a log: 1. Make the Query Log tab visible by following the instructions in "Accessing the Excel Client Query Log" (page 60). created. Saving and Exiting the Excel Client To exit the HP 3PAR System Reporter Excel client workbook, on the File menu, click - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 62
and the data connection, choose the Enable this content buttons. NOTE: If it is ever necessary, you can obtain an entirely new copy of the HP 3PAR System Reporter Excel client workbook by following the instructions provided in "Installing the Excel Client (Optional)" (page 47). 62 Getting Started - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 63
. NOTE: For information on using a Web browser to edit database sampling policies, adding or removing storage servers from the database, scheduling reports or optimizing storage utilization with the optional Adaptive Optimization feature, see "Configuring the System Reporter Policy Settings" (page - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 64
Figure 23 Quick Reports Window Accessing Scheduled Reports Scheduled reports are generated using preselected parameters at scheduled times and are stored in subdirectories whose structure is reflected in the tree shown in Figure 24 (page 65). Scheduled reports are stored with a name that is assigned - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 65
Figure 24 Scheduled Reports Window NOTE: See"Scheduling Reports" (page 122) for complete details on scheduling a report. Creating Custom Reports You can create customized reports by selecting the Custom Reports tab from the Main Menu or by choosing the Excel Client from the Extras Menu. NOTE: The - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 66
For more information, see: "Building the Report Menu" (page 66) "Generating the Report" (page 68) "Controls Available by Report" (page 71) "Report Selection" (page 75) "Time Selection" (page 84) "Object Selection" (page 85) "Format Selection (Web interface only)" (page 92) Building the Report Menu - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 67
for each resolution (see "Editing Sampling Policies" (page 115) for instructions on altering the default sampling policies). Since a different set of types of statistics provided by this report. Node Cache Performance Display Node Cache Performance. See "Node Cache Performance Reports" (page 110) - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 68
) Reports Purpose Link Performance Display performance of links between nodes. See "Link Performance Reports" (page 111) for : When selecting systems for System Reporter where there are multiple HP 3PAR StoreServ Storage systems available for reporting, consider limiting the number of systems - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 69
Figure 26 Report Menu for Daily VLUN Performance The top of the report menu includes a section that lists the current selection of systems of domains. In this example, the menu includes only system named unicorn and all domains. For most reports, the controls in the report menu are divided into four - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 70
Use the controls in the menu to select the desired report parameters and then click Generate Report. See Figure 26 (page 69) for a listing of the controls that are available for each report and then consult the relevant sections later in this chapter for complete details. CAUTION: Filtering large - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 71
Figure 27 Query Results If necessary, use the scrollbox on the right to view all charts and/or tables. Controls Available by Report Table 10 (page 72) lists the set of controls that are valid for generating each report. The entries have the following meanings: • A blank entry indicates that the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 72
Table 10 Controls for Each Report Report: Summayr PD CPG LD VV PD Port LD VLUN VV Node CPU Link Adaptive Section and Space Space Space Space Perf Perf Perf Perf Cache Cache Perf Perf Optimization Control Perf Perf Main Menu "Sample Y Y Y Y Resolution" ( - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 73
Table 10 Controls for Each Report (continued) Report: Summayr PD CPG LD VV PD Port LD VLUN VV Node CPU Link Adaptive Section and Space Space Space Space Perf Perf Perf Perf Cache Cache Perf Perf Optimization Control Perf Perf "End Time" (page 85) T T T - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 74
90) YY Y "Select Port Y Rates" (page 90) "Select Ports (n:s:p)" (page 90) "Select Hosts" (page 91) Y Y "Select Nodes" (page 91) YY Y "Select To Y Nodes" (page 91) "Select Y Queues" (page 91) Format Selection "Report Information" (page 92) YYY YY Y YY YY Y Y Y "Chart - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 75
Table 10 Controls for Each Report (continued) Report: Summayr PD CPG LD VV PD Port LD VLUN VV Node CPU Link Adaptive Section and Space Space Space Space Perf Perf Perf Perf Cache Cache Perf Perf Optimization Control Perf Perf "Chart Y Pixels" (page 97) - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 76
with System and Host selected in the Group By control and IOPs/s selected in the Order By control. Display service time histogram versus time, with a separate data series for each service time bucket between the Low Bucket (see "Low Bucket" (page 84)) and the High Bucket (see "High Bucket" (page - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 77
Figure 28 Versus Time Report Example In the aggregate performance of all the selected objects (possibly in multiple systems) is shown. Typically, some components of the metric may be shown separately, for example Read and Write metrics are shown separately. Creating Custom Reports 77 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 78
Figure 29 Versus Time with Compare=System Report Example If you want to compare the performance of a particular class of objects (for example, systems), then you can use the Compare control (see "Compare" (page 81)) available in some reports if the Report Type is Versus Time. Figure 29 (page 78) - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 79
Figure 30 Group By System:Host At Time Report Example The At Time report can be used in conjunction with the Group By and Order By controls to do more detailed comparisons at a specific point in time. Figure 30 (page 79) shows an At Time report with System and Host selected in the Group By control - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 80
31 Histogram Versus Time Report Example The Histogram Versus Time report provides a histogram or service times for the aggregate of the selected objects as shown in "Histogram Versus Time Report Example" (page 80). There is a separate line per service time bucket. 80 Accessing and Creating Reports - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 81
Figure 32 Histogram At Time Report Example The Histogram At Time report provides a histogram or service times and IO sizes at a specific time for the aggregate of the selected objects as shown in "Histogram At Time Report Example" (page 81). Select - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 82
, see Table 12 (page 82). Table 12 Group By Option System Domain RAID Type Node CageID Mag PDID ProvType Disk DiskType DiskSpeed LD LDUsage VV VVType CPG UsrCPG SnpCPG PortNode n:s:p Purpose Group by HP 3PAR StoreServ Storage. Group by domain name. Group by RAID Type. See "Select RAID Types" (page - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 83
UsrCPG SnpCPG PortNode n:s:p SelChunkSize IOPs/s Bandwidth Service Time IO Size Purpose Order by HP 3PAR StoreServ Storage. Order by domain name. Order by RAID Type. See "Select RAID Types" (page 88) for the list of RAID types and descriptions. Order by Controller Node. Order by Cage ID. Order by - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 84
and node cache performance. ReadHit% Order by read hit% for VV and node cache performance. WriteHit% Order by write hit% for VV and node cache is only valid for Histogram Versus Time reports and specifies the lowest service time bucket that will be included in the report. High Bucket This - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 85
of specific time values Purpose End with the most recent sample available. End at the specified time value. The values in the menu are populated based on the actual samples in the selected data table. Count This control is only valid for Histogram At Time or Histogram Versus Time reports. Table - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 86
Select PDIDs This is a filtered multi-selection control (see "Filtered Multi-Selection Control" (page 53)) used to select one or more PDIDs to include in the report. This control is available for PD Space and PD Performance reports. Table 17 Select PDIDs Option -All PDIDslist of specific PDIDs - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 87
to provision its snapshot copy space. For thin provisioned VVs, this snapshot copy space was also used for provisioning the base VV's space (the usr space). Beginning with the HP 3PAR OS release 2.3.1, thinly-provisioned VVs can have separate spaces and corresponding separate CPGs to provision the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 88
Table 24 Select Snp CPGs Option -All CPGslist of specific CPGs Purpose The report will include all the Snp CPGs that are included in the database. Select one or more Snp CPGs to include in the report. Multiple CPGs can be selected. Select CPGs This is a filtered multi-selection control (see " - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 89
storing data during physical disk replacement operation. Typically, each Controller Node has 20 GB of logging LD space. Select LUN This is be selected using (CTRL-CLICK). For VV Space reports, these only include base VVs, not snapshots. For VLUN Performance reports these include only VVs that - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 90
. Select one or more VV Types to include in the report. Multiple VV Types can be selected using (CTRL-CLICK). VV Types include: • base - Base volume (not a copy) • pcopy - Physical (full) copy • vcopy - Virtual copy (snapshot) Select Port Types This control is only available for Port Performance - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 91
in the report. Multiple ports can be selected using (CTRL-CLICK). The format for ports is n:s:p where • n is the controller node • s is the PCI slot in the controller node • p is the port number in a PCI slot Select Hosts This is a filtered multi-selection control (see "Filtered Multi-Selection - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 92
Format Selection (Web interface only) The format selection controls are used to specify how the output of a given report is formatted for presentation. For more information, see: "Report Information" (page 92) "Chart Lib" (page 92) "Chart Types" (page 93) "Chart X Pixels" (page 97) "Chart Y Pixels" - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 93
IE9, Firefox, and Google Chrome browsers currently offer this support). Chart Types Stacked charts stack data on top of example, in performance charts, the average service time for I/O is not the sum of the average service time for reads plus the average service time for writes. Similarly, the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 94
You can choose from the following chart types: • Stacked Bars Figure 34 Chart Using Stacked Bars • Stacked Vert Bars 94 Accessing and Creating Reports - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 95
Figure 35 Chart Using Stacked Vertical Bars • Stacked Area Figure 36 Chart Using Stacked Areas • Lines Creating Custom Reports 95 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 96
Figure 37 Chart Using Lines • Bars Figure 38 Chart Using Bars 96 Accessing and Creating Reports - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 97
Position You can choose the position of the chart legend. Table 40 Legend Position Option Auto Bottom Right Purpose Legend position is chosen automatically based on the Chart Type. Legend is placed below the chart. Legend is placed to the right of the chart. Time Format This control selects - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 98
Full Relative Purpose Time format is chosen automatically based on the sample resolution. If resolution is hours, 50 mins, 3 secs ago). Select Space Unit This control selects the units in which storage space is represented. It is only valid for space reports. Table 42 Select Space Unit Option - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 99
schedule by modifying the properties of query table from which the charting information is derived. When the table data is refreshed, any charts based on the table will also be refreshed. Setting a table to be automatically refreshed is most applicable with a table that was created using relative - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 100
the Refresh every checkbox and enter the desired value. Figure 42 External Data Range Properties Dialog Box 3. Click OK. Retaining Charts The HP 3PAR System Reporter Excel client workbook is designed to reuse data sheets, redrawing charts on the reporting tool sheets with updated data or modified - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 101
chart and the data sheet linked to that chart to new worksheets. See the instructions that follow for a detailed description of how to complete this procedure. To retain to plot the results of database queries initiated with the HP 3PAR System Reporter Excel client. To customize a chart, you must - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 102
not be possible if knowledge of the altered password were to become unavailable for some reason. Adding Custom Columns to a Data Sheet The following instructions illustrate how to add custom columns to a data sheet. In this example, you will add the custom columns Non-failed spare and Percent spare - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 103
the new workbook, the ability to create new charts using the same formulas is preserved. NOTE: To obtain an entirely new copy of the HP 3PAR System Reporter Excel client workbook, follow the instructions provided in "Installing the Excel Client (Optional)" (page 47). Working with Excel Charts 103 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 104
Hosts Exported VVs Description Shows all columns. IP Address of the HP 3PAR StoreServ Storage. The HP 3PAR OS revision. The HP 3PAR StoreServ Storage model. Serial number of the HP 3PAR StoreServ Storage. Number of controller nodes. Number of hosts. Number of distinct VVs exported as VLUNs. Shown - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 105
Average percentage of time that the CPUs are busy on all controller nodes. Shown by default. Host Read IOPs Host Write IOPs Host Total (reads + writes) bandwidth in KBytes/s to PDs. Total (reads + writes) average service time in millisec to PDs. Total (reads + writes) average IO size in KBytes to - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 106
Table 43 Summary Report Metrics (continued) Metric Description Shown by default. Used PD Capacity GiB Total PD Capacity GiB Used PD space. Total PD space available. Shown by default. Free (FC 10,15K), (NL 7k), (SSD) Free space for a specified drive in GIBs. RPM PDS Capacity GiB Used (FC 10,15K - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 107
are shown for the Physical DIsk (PD), Common Provisioning Group (CPG), Logical Disk (LD), and Virtual Volume (VV) space reports used to determine storage capacities and usage. PD Space Reports PD (Physical Disk) Space reports show the amount of physical disk space composed of chunklets according to - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 108
Description User Raw Rsvd Space Raw physical disk space reserved for User (base volume) Space for the selected VVs. This is zero for Virtual Copy Copy (snapshot) VVs. User Rsvd Space Space that is reserved for User (base volume) Space for the selected VVs. This is zero for Virtual Copy (snapshot - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 109
Beginning with the HP 3PAR OS 2.3.1 release running the updatesnapspace command can be scheduled periodically on the HP 3PAR StoreServ Storage. Admin Used read + write) bandwidth in KBytes/s. Average read service time in millisec. Average write service time in millisec. Performance Reports 109 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 110
and VLUN Performance reports show the read counts, write counts or total counts in various service time buckets. Depending on the Count control (see "Count" (page 85)), these + writes). Not shown in charts. Node Cache Performance Reports Table 50 (page 111) describes the metrics that are shown for - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 111
than 1 time. Number of pages scheduled to be written to disk. Number of pages being currently written by the flusher to disk. During node down, number of dead node pages recovered that have to be written to disk. CPU Performance Reports Table 51 (page 111) describes the metrics that are shown for - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 112
Description Shows IO rate density for a given region. Shows movement on a given VV for a type of tier. Space moved between tiers. NOTE: Adaptive Optimization reports supports reporting for only one system at a time. 112 Interpreting Report Metrics - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 113
options are available from the menu tabs: • Sampling Policies -- Configures report sampling policies. • InServ Systems -- Specifies the HP 3PAR StoreServ Storage systems to include for sampling and subsequent report generation and optional optimization. • Alert Rules -- Specifies alert rules for - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 114
with sampling, send email to this address. (blank) Email is only sent if the sampling problem requires the sampler service/daemon to exit. Compacting Databases When some sampling policies are changed or when the number or sizes of systems being sampled is reduced the size - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 115
support using Microsoft SQL with Linux systems. Editing Sampling Policies To edit a System Reporter database sampling policy: 1. Access HP 3PAR System Reporter by pointing your browser at the Web server where Apache HTTP Server and the HP 3PAR page 48) for more instructions on setting Apache HTTP - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 116
HTTP Server Authorization and Access Control" (page 48) for more instructions on setting Apache HTTP Server to require a username and password in Sampling Policies window. Adding, Removing and Re-Configuring HP 3PAR StoreServ Storage Systems System Reporter can sample multiple systems and place - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 117
storage server but does not remove the database or remove HP 3PAR System Reporter or any of its components. See "Removing the System Reporter Components" (page 49) for deinstallation instructions. Re-Configuring a Storage IP address for the selected HP 3PAR StoreServ Storage. • Use SSL -- Specifies - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 118
Policies window. Changing an Alert Rule To change an alert rule: 1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR System Reporter Web server scripts are installed. The 3PAR System Reporter main window appears. 2. Click Policy Settings in the Extras Menu area. The - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 119
Table The data table on which the rule operates. The currently supported data tables are described in Table 55 (page 119). Table of IOPs/s and bandwidth of a node by host. statport_syssum Represents the sum of all the ports on an HP 3PAR StoreServ Storage. This allows you to generate alerts - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 120
the HP 3PAR StoreServ Storage. statpd_ssd150sum Represents the aggregation of all the SSD PDs of speed 150 in the HP 3PAR StoreServ Storage. statld, VLUNs for statvlun and nodes for statcpu). The supported metrics depend on the value of Data Table. Currently supported metrics are described in Table - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 121
statpd_ssd150, statld, statvlun total_svctms Total (read + write) service time in millisec statport, statpd, statpd_nl7,statpd_fc10, statpd_fc15, statpd_ssd150, statld, statvlun idle_perc Percentage idle time for the node statcpu total_utilperc Total utilization per second. For instance, when - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 122
it inserts a high-resolution sample in which more than 0 (Limit Count) VLUNs (including VLUNs in all systems) has a total (reads and writes included) average service time in millisecs of greater than (>) 1000 (Limit Value). Figure 47 Example of an alert rule An example of the email alert is shown - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 123
Report To add a scheduled report: 1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR System Reporter Web server scripts are installed. The 3PAR System Reporter main window appears. 2. Click Policy Settings in the Extras Menu area. The System Reporter Policies window - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 124
browser at the Web server where Apache HTTP Server and the HP 3PAR System Reporter Web server scripts are installed. The 3PAR System Reporter main window appears. 2. Click Policy Settings in can be used to monitor and optimize storage utilization. 124 Configuring the System Reporter Policy Settings - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 125
to limit file access as desired. The minimum level for correct operation is READ access by the SYSTEM account (the Apache HTTP Server and HP 3PAR System Reporter services run as the SYSTEM account). For Windows Systems If System Reporter has been configured to use MySQL, Microsoft SQL or Oracle, the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 126
close the file. 5. Go to the Apache HTTP server cgi-bin directory and locate the 3par-rpts subdirectory (for example, (for example, C:\Program Files\ApacheGroup\Apache2\cgi-bin\ 3par-rpts). 6. In the 3par-rpts subdirectory, locate the config.tcl file (for example, C:\Program Files\Apache Software - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 127
scripts or code processing it. To determine if your processing code is compatible with the server, issue the following query: http:///cgi-bin/3par-rpts/inserv_perf.exe?report=version where is the name of your server. The following is an example of the table returned: About - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 128
Figure 50 System Reporter Version Report This query returns a 3x3 table with the column headers Category, Major, and Minor. The two rows after the header contain major and minor numbers for Product and ReportData. The Product version numbers are informational only and are the numbers assigned to the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 129
is sampled once an hour. hires Specifies that results will be pulled from the hires database table. For the hires database table, the storage server is sampled every 5 minutes (by default) or less frequently, depending on how the database sampling policy has been configured (see "Editing Sampling - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 130
available for the vv_space_time report. SnpCPG Compares selected Snp CPG. This value is only available for the vv_space_time report. Node Compares selected controller nodes. This value is only available for the cpu_perf_time report. CageID Compares selected drive cages. This value is only available - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 131
) The total (read + write) IOPs for the object. total_kbps The total (read + write) bandwidth (KBytes/s) for the object. total_svctms The total (read + write) service time in millisec for the object. total_qlen The total queue length for the object. busy_pct The percentage of time that the object is - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 132
The virtual size. table Use the table option to specify a table from which data is returned when using one of the objects_present reports (see "Objects Present Reports" (page 169)). This option can only be specified once in a given query string. values: Specify one of the following: ldspace - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 133
segments, they are not suitable for some forms of data. For example, in performance charts, the average service time for I/O is not the sum of the average service time for reads plus the average service time for writes. Similarly, the average size for I/O is not the sum of the average I/O size of - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 134
Specifies that charts will use stacked vertical bars. Stacked charts stack data on top of each other so you can see the total as well. See Figure 35 (page 95) for an example of a chart using stacked vertical bars. stackedarea Specifies that charts will use stacked areas instead of stacked bars. See - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 135
graphlegpos Use the graphlegpos option to specify the position of the chart legend. If not defined, the legend position is selected automatically based on the charttype. This option can only be specified once in a given query string. value: bottom The legend is placed below the chart. right The - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 136
example: The following example specifies that all the time axis points should be labelled: &alllabels=1 timeform Use the timeform option to specify a time format (either relative or absolute) when using a report that requires a time range. This option can only be specified once in a given query - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 137
If is non-negative it represents a point in time, expressed as the number of seconds since January 1, 1970, GMT. For example, to express 2005/07/13 11:00:34 as a value, use the value 1121277634. If is negative, it represents a point in time seconds before the current - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 138
and special characters (for example: n%3As%3Ap). PortNode Group results by port node number (The n part in n:s:p). RaidType Group results by RAID level (for by physical disk ID number. Node Group results by controller node number (0-7, depending on the storage server model and configuration). 138 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 139
PortType Group results by port type. example: The following example specifies that results should be grouped by system: &groupby=System The following example specifies that results should be grouped by system, drive magazine, and physical disk ID: &groupby=System&groupby=Mag&groupby=PDID orderby Use - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 140
Order results by physical disk ID number. Node Order results by controller node number (0-7, depending on the storage server model and configuration). IOPs Order results by I/O per second. Bandwidth Order results by bandwidth. Service Time Order results by service time. For this value, an escape - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 141
Order results by CPU context switches/sec. VirtSize Order results by VV virtual size. TotalRsvdSize Order results by VV reserved space size. TotalRawSize Order results by VV total raw reserved space size. LDSize Order results by total LD size. LDFreeSize Order results by total free LD size. - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 142
example: The following example specifies that the histogram should include all accesses: &histbegin=1 ldspaceunit Use the ldspaceunit option to determine the unit of measure for logical disk space reports. This option can only be specified once in a given query string. values: Specify one of the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 143
: &vvspaceunit=GiB%20%282%5E30%20bytes%29 selcageid Use the selcageid option to select a drive cage. When no value is specified, no cages are excluded based on their cage IDs. Report Options 143 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 144
=5 selchunks Use the selchunks option to include chunklets according to their chunklet type. If no value is specified, no chunklets are excluded based on their chunklet states. values: Specify one or more of the following: NRM_USED_OK Include only normal used chunklets that are OK. NRM_USED_FAIL - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 145
to select a common provisioning group (CPG). value: Specify one or more of the following: --All CPGs-(Default). This value does not exclude CPGs based on their names. This value consists of a CPG name. example: The following example shows to ways to include all CPGs regardless of name - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 146
the following: --All Disk Types-(Default). This value does not exclude disks based on their type. FC This value allows you to include only Fibre Channel the following: --All Disk Speeds-(Default). This value does not exclude disks based on their speed. 15 This value allows you to include only 15K RPM - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 147
a host according to the host name. value: Specify one or more of the following: --ALL Hosts-(Default). Does not exclude any hosts based on host names. This value consists of a storage server host name. example: The following example shows two ways to specify that no hosts be excluded - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 148
select logical disks according to their LD names. value: Specify one or more of the following: --All LDs-(Default). Does not exclude logical disks based on their names. This value consists of a logical disk name. example: The following example shows two ways to specify that LDs not be - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 149
no ports are to be excluded based on location. This value consists of a port position location expressed in format, where (0,1,2,3,4,5,6 or 7) is a node number (which depends on the number of nodes and the storage server model), (0-5 for each node) is a node PCI slot numbered - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 150
disks according to their state (valid or Not valid). values: Specify one or more of the following: --All PD States-(Default). PDs are not excluded based on their state. valid Specify this value to include all valid physical disks. Not valid Specify this value to include only physical disks that do - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 151
example: The following example shows two ways to specify that physical disks are not to be excluded based on their states: &selpdstate= OR &selpdstate=--All%20PD%20States-- The following example specifies that only physical disks with a current state of Not valid should be - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 152
server system name. example: The following example shows two ways to specify that storage servers should not be excluded based on their names: &selsys= OR &selsys=--All%20Systems--& The following example includes data from InServ1: &selsys= InServ1 selvv Use the selvv option to specify virtual - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 153
--All VV Types-(Default). Does not exclude virtual volumes based on their types. base Select base VVs. vcopy Select Virtual Copy (snapshot) VVs. pcopy separate User and Snap spaces. tpsd Select old-style (created before HP 3PAR OS release 2.3.1) thinly-provisioned VVs that have user and snapshot data - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 154
Summary Report summary Shows summary information for all systems. example: The following example shows the entire query string for a summary report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?category=daily&pdspaceunit=Chunklets&report=summary 154 Web Queries - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 155
(on the x-axis). example: The following example shows the entire query string for an ld_space_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& endtsecs=&timeform=absolute&ldspaceunit=MiB%20%282%5E20%20bytes%29& selsys - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 156
free and used space. example: The following example shows the entire query string for a vv_space_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& endtsecs=&timeform=absolute&vvspaceunit=MiB%20%282%5E20%20bytes%29&selsys - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 157
performance. pd_perf_time Returns a chart and/or table of performance metrics (IOPs, bandwidth, service time, I/O size) for physical disks versus time, limited by any options selecting a pd_perf_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars& - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 158
Returns a chart and/or table of performance metrics (IOPs, bandwidth, service time, I/O size) for ports versus time, limited by any options query string for a port_perf_group report: http://localhost/cgi-bin/3par-rpts /inserv_perf.exe?category=daily&charttab=chart&charttype=stackedbars&refresh=& - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 159
a chart and/or table of performance metrics (IOPs, bandwidth, service time, I/O size) for logical disks versus time, limited by entire query string for a ld_perf_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs= & - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 160
for a ld_svt_hist report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& selsys=--All%20Systems--&selld=--All%20LDs--&histbegin=1&report=ld_svt_hist ld_svt_histvstime Plots the service time histogram of all the logical disks in - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 161
=--All%20Ports--&histbegin=1&report=vlun_svt_hist vlun_svt_histvstime Plots the service time histogram of all the VLUNs (exports) string for a vv_cmp_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?category=daily&charttab=chart&charttype= systems or nodes. Performance Reports 161 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 162
at a specific time, grouped by system and/or node. example: The following example shows the entire query string for a cpu_perf_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& selsys=--All%20Systems--&selnode=--All - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 163
vvtier example The following example shows the entire query string for a vvtier report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&selsys=3par1&report=vvtier Options Available by Report The following figures display the options that are valid for - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 164
Figure 51 Valid Options for Summary, Space and Adaptive Optimization Reports (I) 164 Web Queries - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 165
Figure 52 Valid Options for Summary, Space and Adaptive Optimization Reports (II) Options Available by Report 165 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 166
Figure 53 Valid Options for Summary, Space and Adaptive Optimization Reports (III) Figure 54 Valid Options for Performance Reports (I) 166 Web Queries - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 167
Figure 55 Valid Options for Performance Reports (II) Options Available by Report 167 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 168
Figure 56 Valid Options for Performance Reports (III) Figure 57 Valid Options for Performance Reports (IV) 168 Web Queries - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 169
, the following query string produces the output displayed at the top in Figure 58 (page 169): http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=cpg_name&table=ldspace& category=hourly&tableformat=excel Removing tableformat=excel from this query string produces - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 170
on page 8.70 ldspacestatld objects_present&"objectpres=node" (page 174)objectpres=node on page 8.71 statcpu objects_present&" query string for: objects_present&objectpres=cageid http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=cageid&table=pdspace& category - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 171
(CPG) names. example: The following example shows the entire query string for: objects_present&objectpres=cpg_name http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=cpg_name&table=ldspace& category=hires output: Returns a row for each common provisioning group - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 172
a list of disk types. example: The following example shows the entire query string for: objects_present&objectpres=disktype http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=disktype&table=pdspace& category=daily output: Returns a row for each disk type on each - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 173
of host names. example: The following example shows the entire query string for: objects_present&objectpres=host_name http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=host_name&table=statvlun& category=daily output: Returns a row for each host present over the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 174
example shows the entire query string for: objects_present&objectpres=node http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=node&table=statcpu& category=hourly output: Returns a row for each node present over the time range for each system. Output columns - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 175
query string for objects_present&objectpres=port http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=port&table=statvlun name • N:S:P: The port location specified as controller node number:PCI slot number:port number The following is example output of the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 176
objectpres= system Returns a list of storage systems. example: The following example shows the entire query string for objects_present&objectpres=system using: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=system&table=pdspace& category=daily output: Returns a - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 177
volumes. example: The following example shows the entire query string for: objects_present&objectpres=vv_name_nosnap http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=vv_name_nosnap&table=vvspace& category=daily output: Returns a row for each volume present - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 178
sample_times Returns valid times of database samples. example: The following example shows the entire query string for: sample_times http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=sample_times&category=daily&table=pdspace output: Returns a row for each time sample in the given table for - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 179
Objects Present Reports 179 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 180
supported only by HP 3PAR OS versions 2.3.1 MU 1 through 3.1.1. For HP 3PAR OS versions 3.1.2 and later, Adaptive Optimization is implemented within HP 3PAR defined for an HP 3PAR StoreServ Storage array where average access rates for each CPG (tier). Based on the space available in each tier, and - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 181
for Adaptive Optimization To begin using Adaptive Optimization on an HP 3PAR StoreServ Storage array, you must either add it configured to include collection of data (region-level data) for sampling purposes (see "Adding Storage Systems" (page 46)) or change the configuration to include the data - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 182
configuration when it is created. • InServ -- Name of the HP 3PAR StoreServ Storage for which the configuration is implemented. • Tier # CPG Name . The CPG definition includes all the parameters necessary to define a storage tier's quality of service: the disk type, disk speed, RAID type, etc. You - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 183
space and Snapshot copy space for a CPG can be examined using the HP 3PAR OS CLI showvv -cpg alloc command. Since this space may need to 2. The reason it needs two times the grow size is that the HP 3PAR StoreServ Storage does not currently allow usr space for fully provisioned VVs and Snap space - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 184
that the CPG is not the default CPG for snapshot and base TPVV allocation otherwise new VV space may get mapped to that CPG. NOTE: See "Adding Storage Systems" (page 46) for details on adding an HP 3PAR StoreServ Storage. Schedule The schedule consists of three components: dates, weekdays and hours - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 185
available from the pull-down menu are added through the InServ Systems tab in the System Reporter Policies window. NOTE: When you add a new HP 3PAR StoreServ Storage to be sampled, the system, its domains and the CPGs that are available may not appear until after the CPG space data has been sampled - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 186
, click Remove Adaptive Optimization. The Remove Adaptive Optimization Configuration window appears. 2. Choose the configuration to remove from the pull-down menu based on tiers that are defined. 3. When done, click Submit Query. An alert window appears confirming that the Adaptive Optimization has - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 187
Density Showing Total Space Figure 62 Region IO Density Showing Total IO Access Each region is put into the appropriate histogram bucket on the X-axis based on its IO access rate during the specified time period. The Y-axis (value) for the first chart is the total space for the regions in - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 188
Some features provided by the cumulative reports are only implemented by the charts provided through the Excel client due to limitations of the web based charting capabilities. VV Tiers Report The VV Tiers report shows the distribution of space in each VV among the tiers in an Adaptive Optimization - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 189
Figure 65 VV Tiers Report Adaptive Optimization Space Moved Report The Space Moved report shows the space moved over a selected time interval for each Adaptive Optimization configuration (Figure 66 (page 189)). Figure 66 Space Moved Report The space moved between tiers represents a performance - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 190
sourced from the CLI. Once you start the CLI and connect to the HP 3PAR StoreServ Storage array, you can source the showvvcpg.tcl command: cli% source showvvcpg.tcl >...). -sortcol [,][:[,]...] Sorts command output based on column number (). Columns are numbered from left - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 191
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-sw esx-fc-r1 224 - 249088 - - esx-sw esx-ssd-r1 288 - 16512 - - esx-rdm-mysqlserver esx-fc-r1 384 1024 44032 - - esx-rdm-mysqlserver esx-ssd-r1 128 - - - - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 192
prepared to revise their applications accordingly. HP does not provide direct assistance in table names. Administrative tables contain only the base name and version number. For example policy_1 by the System Reporter when the sampling service starts. Administrative Tables The administrative tables - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 193
address of the system to sample. Determines whether CLI connections to the HP 3PAR StoreServ Storage will use SSL. 0 - Do not use SSL 1 - Use SSL frequency. See "Service Time Histogram Buckets" (page 208). VARCHAR(32) NOT NULL IP Address of the system. VARCHAR(32) NOT NULL HP 3PAR OS revision. - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 194
system_3 table. VARCHAR(32) NOT NULL The metric that is calculated. The supported values depend on the data_table value. VARCHAR(32) NOT NULL How the than). DOUBLE PRECISION NOT NULL The calculated metric is compared based on direction against limit_val. INTEGER NOT NULL In each sample - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 195
INTEGER PRIMARY KEY A unique identifier for each scheduled report. (AUTO_INCREMENT) VARCHAR(64) NOT NULL The top level report directory (under the 3par/ scheduledreports/ directory). VARCHAR(64) NOT NULL The report name. A sub-directory of this name is created (under the rpt_dir directory) in - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 196
Table 65 adprovconfig_1 Table (continued) Column Type Comment ap_sched VARCHAR(200) NOT NULL The schedule for when this adaptive optimization configuration should be run. The format is a space-separated list of three items: the date list, the weekday list and the hour list. Each of these three - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 197
Table 67 ldrgmoves_1 Table (continued) Column adprovid ldid ld_name ldoffmb vvid vvspace vvoffmb src_tier dst_tier dst_cpgname move_reason Type Comment INTEGER PRIMARY KEY (AUTO_INCREMENT) A unique identifier for each adaptive optimization configuration. INTEGER NOT NULL The logical disk ID - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 198
Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. A unique identifier for the HP 3PAR StoreServ Storage instance refers to the uniq_id for the system instance in the system_3 table The physical disk ID. The cage ID that the PD is in - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 199
Table 69 pdspace__3 Table (continued) Column Type Comment NRM_USED_FAIL INTEGER NOT NULL Number of normal chunklets that were used in LDs but have failed. NRM_AVAIL_CLEAN INTEGER NOT NULL Number of normal unused chunklets that have been initialized. These are free for use in new LDs. - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 200
VARCHAR(32) NOT NULL VARCHAR(32) NOT NULL VARCHAR(32) NOT NULL VARCHAR(32) NOT NULL VARCHAR(32) NOT NULL The node number of the owner of the LD. The node number of the backup owner of the LD. The RAID type of the LD The set size of the LD. Step - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 201
• FC - Fibre channel drive. • NL - Nearline drive. The node number of the owner of the LD. The node number of the backup owner of the LD. The RAID type of domain, this column contains the value "-". The virtual volume ID. The ID of the base VV for the VV. The VV name. The WWN of the VV. The name of - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 202
the VV (see the Prov column for the showvv CLI command in HP 3PAR OS 2.3.1 or later). vv_type VARCHAR(32) NOT NULL The VV Type (see the Type column for the showvv CLI command for HP 3PAR OS 2.3.1 or later). copyof VARCHAR(32) NOT NULL The name of the VV - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 203
value "-". INTEGER NOT NULL The virtual volume ID. INTEGER NOT NULL The ID of the base VV for the VV. VARCHAR(32) NOT The VV name. NULL CHAR(16) NOT (see the Prov column for the showvv CLI NULL command in HP 3PAR OS 2.3.1 or later). VARCHAR(32) NOT The VV Type (see the Type column for - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 204
Table 75 cpgspace__1 Table Column tsecs sys_uid dom_name cpgid cpg_name adm_total_mb adm_rawtotal_mb adm_used_mb adm_rawused_mb snp_total_mb snp_rawtotal_mb snp_used_mb snp_rawused_mb usr_total_mb usr_rawtotal_mb usr_used_mb usr_rawused_mb warn_mb limit_mb gsize_mb rawfree_mb usablefree_mb - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 205
The cpgspaceinv Table The cpgspaceinv__1 table holds the inventory for the cpgspace_1 table. Table 76 cpgspaceinv__1 Table Column tsecs sys_uid dom_name cpgid cpg_name Type Comment INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00: - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 206
PRECISION Difference between rhist0 value from last sample for the same object. NOT NULL ... ... ... rhist31 DOUBLE PRECISION Number of reads in service time bucket number 31. NOT NULL d_rhist31 DOUBLE PRECISION Difference between rhist31 value from last sample for same object. NOT NULL 206 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 207
DOUBLE PRECISION Difference between whist0 value from last sample for the same object. NOT NULL ... ... DOUBLE PRECISION Number of writes in service time bucket number 31. NOT NULL DOUBLE PRECISION Difference between whist31 value from last sample for same object. NOT NULL DOUBLE PRECISION - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 208
.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 INTEGER NOT NULL The node that the disk's primary port is connected to (the "n" part of n:s:p). 208 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 209
n:s:p). port_p INTEGER NOT NULL The port number in the PCI slot in the node that the disk's primary port is connected to (the "p" part of n:s:p). of n:s:p). INTEGER NOT NULL The port number in the PCI slot in the node that the disk's primary port is connected to (the "p" part of n:s:p). - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 210
The statldinv__4 table holds the inventory for the statld__5 table . Table 82 statldinv__4 Table Column tsecs sys_uid dom_name ldid node cpg_name Type INTEGER NOT NULL INTEGER NOT NULL VARCHAR(32) NOT NULL INTEGER NOT NULL INTEGER NOT NULL VARCHAR(32) NOT NULL Comment Sample time - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 211
system instance in the system_3 table. The node that the port is connected to (the "n" part of n:s:p). The PCI slot in the node that the port is connected to (the "s" part of n:s:p). The port number in the PCI slot in the node that the port is connected to (the "p" part of n:s:p). The port type - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 212
of n:s:p). port_p INTEGER NOT NULL The port number in the PCI slot in the node that the port is connected to (the "p" part of n:s:p). (common performance n:s:p). INTEGER NOT NULL The port number in the PCI slot in the node that the port is connected to (the "p" part of n:s:p). The statvvcmp - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 213
The VV name. The statcpu Table The statcpu__1 table holds CPU performance data samples. Table 89 statcpu__1 Table Column tsecs sys_uid node cpu usert Type Comment INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 214
statcpuinv Table The statcpuinv__1 table holds the inventory for the statcpu__1 table. Table 90 statcpuinv__1 Table Column tsecs sys_uid node cpu Type INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL INTEGER NOT NULL Comment Sample time in secs. This is the Unix time and - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 215
DOUBLE PRECISION NOT Total number of transfers on the queue since the node was started. NULL DOUBLE PRECISION NOT Difference between xfers value from res>_1 table. Table 92 statlinkinv__1 Table Column tsecs sys_uid node node_to queue Type Comment INTEGER NOT NULL Sample time in secs. This - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 216
time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. WRITES DOUBLE Total number of writes on the HP 3PAR StoreServ Storage. PRECISION NOT NULL The statldrg_timeinv Table The statldrg_timeinv_1 table holds the time inventory for the statldrg_hourly_2 table. Table 94 statldrg_timeinv_1 - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 217
of the types of problems encountered include: • The sampler service or daemon stops. • The sampler fails to sample data from a particular HP 3PAR StoreServ Storage. • If there are problems with the Adaptive Optimization components, see "Troubleshooting Adaptive Optimization Components" (page - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 218
process. Errors incurred by the CLI sampler process may include loss of network connectivity to the HP 3PAR StoreServ Storage, a timeout because the CLI process took too long to get the data, or authentication process will continuously log the error and restart. 218 Troubleshooting System Reporter - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 219
the error and exit. Troubleshooting Adaptive Optimization Components Adaptive Optimization components include a regionmover process for each HP 3PAR StoreServ Storage for which adaptive optimization is enabled. Since the regionmover processes are created by the main sampleloop service or daemon, the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 220
, you may want to send that data to HP to help in analyzing a performance problem. This section describes how you can extract all or in the System Reporter directory (by default C:\Program Files\3PAR\System Reporter), and on Linux the sysbck.bin executable is . 220 Troubleshooting System Reporter - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 221
that was assigned while configuring the HP 3PAR StoreServ Storage systems. If you are not sure, go to Policy Settings →InServ Systems to get this parameter. NOTE: The -dbouttype parameter should not be used when extracting data for analysis by HP support. Depending on the -scripttype parameter, the - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 222
cliuser -dbpwfile dbpwfile -dbouttype mysql -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime "07/14/2010" -inservname s074:s138 222 Troubleshooting System Reporter - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 223
• From SQLite to MS SQL: sysbck -dbtype sqlite -db cliuser -dbouttype mssql -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime "07/14/2010" -inservname s074:s138 • From SQLite to Oracle: sysbck -dbtype sqlite -db cliuser -dbouttype oracle - - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 224
file has been copied, you can restart the HP 3PAR System Reporter sampler service (Windows) or daemon (Linux). NOTE: Ideally, when extracting data for HP support from an SQLite database, use sysbck without 2 GB files (if necessary), and is easier to manage. 224 Troubleshooting System Reporter - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 225
type of support you are requesting: HP 3PAR storage system HP 3PAR StoreServ 7200 and 7400 Storage systems HP 3PAR StoreServ10000 Storage systems HP 3PAR T-Class storage systems HP 3PAR F-Class storage systems Support request StoreServ 7000 Storage 3PAR or 3PAR Storage HP 3PAR documentation For - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 226
detailed alert information HP 3PAR F-Class, T-Class, and StoreServ 10000 Storage Troubleshooting Guide Installing, configuring, and maintaining the HP 3PAR Policy HP 3PAR Policy Server Installation and Setup Guide Server HP 3PAR Policy Server Administration Guide 226 Support and Other Resources - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 227
upgrading 7200 and 7400 storage systems Troubleshooting 7200 and 7400 storage systems Maintaining the Service Processor HP 3PAR StoreServ 7000 Storage Service Guide HP 3PAR StoreServ 7000 Storage Troubleshooting Guide HP 3PAR Service Processor Software User Guide HP 3PAR Service Processor Onsite - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 228
followed as directed in order to achieve a functional and supported implementation based on testing at HP. HP 3PAR branding information • The server previously referred to as the "InServ" is now referred to as the "HP 3PAR StoreServ Storage system." • The operating system previously referred to as - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 229
12 Documentation feedback HP is committed to providing documentation that meets your needs. To help us improve the documentation, send any errors, suggestions, or comments to Documentation Feedback ([email protected]). Include the document title and part number, version number, or the URL when - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 230
storage servers, 113 length for retaining samples, 114 sampling policies, 48 troubleshooting, 220 database sampling policies hi-res samples, 113 Decision Support 113 Histogram At Time, 76 hourly data table, 67 hourly samples, 114 HP 3PAR OS Command Line Interface, 23 httpd.conf file, 48 I InForm CLI - HP 3PAR StoreServ 7400 2-node | HP 3PAR System Reporter 3.1.0 Software User& - Page 231
, 24 S sample resolution resolutions, 67 Sample resolution control, 67 sampling a new storage server, 116 sampling components troubleshooting, 217 sampling interval, 113 sampling policies editing, 113 sampling service, 26 Scheduled Reports, 122 Space Moved Report, 189 special considerations, 30
HP 3PAR System Reporter 3.1 Software
User's Guide
Abstract
This guide provides information required to install and use HP 3PAR System Reporter Software to monitor performance, create
charge back reports, and plan storage resources for HP 3PAR StoreServ Storage systems, and is intended for system and
storage administrators who monitor and direct system configurations and resource allocation for HP 3PAR StoreServ Storage
systems.
For HP 3PAR OS 3.1.1 or OS 2.3.1, an optionally licensed component called Adaptive Optimization is also included with
System Reporter that can be used to monitor and automatically optimize utilization of storage resources. If you do not have a
licence for Adaptive Optimization, the monitoring and system reporting features are still accessible but the optimization
capabilities are inactivated.
For HP 3PAR OS 3.1.2 and later, Adaptive Optimization is performed by the HP 3PAR OS. Licensing requirements are the
same whether Adaptive Optimization is implemented on the node (as in HP 3PAR OS 3.1.2) or in System Reporter 3.1.
This help system provides information required to install and use HP 3PAR System Reporter Software to monitor performance,
create charge back reports, and plan storage resources for HP 3PAR StoreServ Storage systems, and is intended for system
and storage administrators who monitor and direct system configurations and resource allocation for HP 3PAR StoreServ Storage
systems. An optionally licensed component called Adaptive Optimization is also included with HP 3PAR System Reporter
Software that can be used to monitor and automatically optimize utilization of storage resources. If you do not have a licence
for Adaptive Optimization, the monitoring and system reporting features are still accessible but the optimization capabilities
are inactivated.
HP Part Number: QL226-96645
Published: December 2012