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.
© Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject 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 or omissions contained herein.
TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document. "Licensor" shall mean the copyright owner or entity authorized by the copyright owner that is granting the License. "Legal Entity" shall mean the union of the acting entity and all other entities that control, are controlled by, or are under common control with that entity.
modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendum to the NOTICE text from the Work, provided that such additional attribution notices cannot be construed as modifying the License.
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 restrictions translate to certain responsibilities for you if you distribute copies of the software, or if you modify it. For example, if you distribute copies of such a program, whether gratis or for a fee, you must give the recipients all the rights that you have. You must make sure that they, too, receive or can get the source code.
Accompany it with the information you received as to the offer to distribute corresponding source code. (This alternative is allowed only for noncommercial distribution and only if you received the program in object code or executable form with such an offer, in accord with Subsection b above.) The source code for a work means the preferred form of the work for making modifications to it.
Contents 1 Overview and Features.............................................................................17 User Interfaces.......................................................................................................................17 About System Reporter............................................................................................................17 Configuring System Reporter Policy Settings................................................................................
3 Getting Started........................................................................................51 Accessing the Main System Reporter Interface............................................................................51 System Reporter Main Menu Window.......................................................................................51 Getting Help..........................................................................................................................
Select Disk Speed.........................................................................................................86 Include PDs in States......................................................................................................87 Select Usr CPGs............................................................................................................87 Select Snp CPGs...........................................................................................................
Configuring Sampling Policies................................................................................................113 Compacting Databases....................................................................................................114 Editing Sampling Policies..................................................................................................115 Adding, Removing and Re-Configuring HP 3PAR StoreServ Storage Systems.................................116 Adding a Storage System...
example:....................................................................................................................134 graphx...........................................................................................................................134 value:........................................................................................................................134 example:.................................................................................................................
value:........................................................................................................................146 example:....................................................................................................................146 seldiskspeed...................................................................................................................146 value:.....................................................................................................................
example:....................................................................................................................155 ld_space_time.................................................................................................................155 example:....................................................................................................................155 ld_space_group...............................................................................................................
regiodensity....................................................................................................................162 regiondensity example.................................................................................................162 regmoves........................................................................................................................162 regmoves example......................................................................................................
8 Using Adaptive Optimization...................................................................180 Overview............................................................................................................................180 Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization............................................181 Configuring Adaptive Optimization.........................................................................................181 Tier Definition (CPG Name and GiB)....
The The The The The The The The statcpu Table.............................................................................................................213 statcpuinv Table.........................................................................................................214 statlink Table.............................................................................................................214 statlinkinv Table....................................................................................
1 Overview and Features This document provides the information you need to install and use HP 3PAR System Reporter to monitor performance, create charge back reports, and plan storage resources 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.
• Scheduling of reports with predefined parameters that are initiated at predetermined times and can then be accessed when needed. • Customization of reports using the standard web interface, (or through the provided Excel client), that provide specifically selected and formatted reports for specified systems.
Quick Reports -- Allows you to immediate access a variety of predefined reports (created through CGI programs) that are deemed useful for most installations. The reports are made available through a menu tree that you expand and collapse to select the systems and options of interest.
Table 1 Available Reports (continued) Report Name Description Report Metrics Cross Reference Node Cache Performance Displays Node Cache Performance. “Node Cache Performance Reports” (page 110) CPU Performance Displays CPU performance. Link Performance Displays performance of links between nodes. “CPU Performance Reports” (page 111) Adaptive Optimization Displays Adaptive Optimization reports.
Formatting Reports for Presentation When building customized reports, you can specify how the reporting data is formatted for viewing by selecting the appropriate table or type of chart.
Using the Database Schema to Build Custom Reports The databases used by System Reporter are standard relational databases capable of supporting SQL queries. The default (built-in) database is SQLite (see http://www.sqlite.org) but MySQL®, Microsoft SQL Server, and Oracle database servers can optionally be used instead. The database schema is documented so you can write your own reports by directly querying the System Reporter database.
2 Installation, Configuration, Update, and Removal Before You Begin Before installing HP 3PAR System Reporter components, select a system on which to run the System Reporter sampler and Web server. This system must use Windows® Server 2012, Windows® Server 2008, or Red Hat® Enterprise Linux 5. If necessary, perform the following setup activities on the designated Windows or Red Hat Linux server: • Install the HP 3PAR OS Command Line Interface (CLI), version 3.1.2. • Install the Apache Server.
System Requirements HP 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 requirements shown in Table 3 (page 24), and also use the sizing spreadsheet described in “Using the System Reporter Sizing Spreadsheet” (page 25).
Using the System Reporter Sizing Spreadsheet Before installing System Reporter, you need to determine the system resources that are required to adequately run System Reporter and the selected data base server. The optimal computing power (CPU cores), memory and storage space needed to accommodate the data that is sampled by System Reporter and used to generate reports depends on the number of systems and the amount of storage that is being monitored for your particular installation.
2. Modify the Sampling Parameters in red to reflect the approximate values for your installation. The values for Table Row Sizes in blue are approximate table row sizes (bytes) based on observations derived by HP during testing System Reporter instances and includes some extra space to accommodate typical inventory tables, indexes, etc. 3.
supports limited concurrency, these functions are performed by the sampleloop process). These include: – The trimdb process removes samples that are older than the sample retention period specified in the sampling policies (see “Configuring Sampling Policies” (page 113)). – The dedupinv process removes duplicate entries from the inventory tables. – The compactdb process periodically compacts and optimizes the database when necessary. • Adaptive Optimization components.
Optional Components Installation of the following components are optional: • Excel client (optional). While the necessary Excel sheet is automatically included, Microsoft Excel is required by the machine accessing the Excel sheet from the System Reporter server. • The Microsoft SQL, MySQL or Oracle database (optional). Except for the SQLite database which is supplied with System Reporter, any other choice of database must be obtained from the respective vendor.
Figure 3 Installation Process Flowchart Installing the Web Server HP 3PAR System Reporter 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.
NOTE: System Reporter 2.9 and beyond supports secure connections on Apache servers using the SSL protocol. For details on implementing the SSL protocol on Apache servers, please consult the following links: http://httpd.apache.org/docs/2.2/ssl/ssl_intro.html http://httpd.apache.org/docs/2.2/ssl/ssl_howto.html http://httpd.apache.org/docs/2.1/ssl/ssl_faq.
the sampler or the Web server can time out. Furthermore, database compaction (see “Compacting Databases” (page 114)) cannot be done in parallel with sample insertion so there could be a large gap in samples during database compaction. Sampling of multiple HP 3PAR StoreServ Storage systems is not supported with an SQLite database, either the Microsoft SQL Server, MySQL or the Oracle database servers should be used instead.
Table 5 Database Comparison (continued) Comment SQLite Microsoft SQL MySQL Oracle Scale to large database No, recommend size? less than 1 GB Yes Yes Yes Scale to large number of No concurrent users? Yes Yes Yes Performance for sample insertion and deletion? Good High Good Adequate for small databases Installing and Setting Up the Microsoft SQL Server Database (Optional) To install the Microsoft SQL Server Database, you must create the database and then set up a valid login and user.
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. 3. Select the System DSN tab. Click Add.
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 option of using the default SQL Server ODBC, if the SQL Server client is already installed on the machine, choose the latest ODBC. 5. Click Finish.
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 Reporter.
9. Click Next. Figure 10 Checking the Details for the Database 10. Click Finish. Figure 11 ODBC Microsoft SQL Server Setup Screen.
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 Server ODBC Data Source Test Screen If the screen does not show the appropriate information, please run the configuration again. Installing and Setting Up the MySQL Database (Optional) To use MySQL, you must install MySQL Database Server, version 5.1, following the instructions provided in this section.
6. Make sure that Configure MySQL Server now is checked and then click Finish. The MySQL Server Instance ConfigurationWizard appears. NOTE: When installing on a Red Hat Linux server where the MySQL server is running locally on the same server, you must complete one of the following procedures: Create a symbolic link using the following command: ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock Or, make the following change in the /etc/my.cnf file: socket=/var/run/mysqld/mysqld.
Setting the max_allowed_packet parameter Change the max_allowed_packet MySQL parameter by editing its value in the MySQL initialization file. • On Linux, the default initialization file is /etc/my.cnf. • On Windows, the default initialization file is C:\Program Files\MySQL\MySQL Server 5.1\my.ini. The initialization file should include the following line: max_allowed_packet=32M After changing the max_allowed_packet parameter, you need to restart the MySQL server.
4. Grant the two users the privilege levels described above by running the commands below: use inservstats grant all on * to cliuser; grant select on * to webuser; exit; 5. Exit the mysql command line by running the following command: exit; Setting Up the Oracle Database (Optional) System Reporter supports the use of MySQL® Database Server or Oracle 11g Database Server. To use Oracle, you must set up Oracle, following the instructions provided in this section.
user names and passwords for the cliuser and the webuser. See “Modifying the Apache HTTP Server Configuration Files” (page 125) for instructions on editing these config.tcl files if you change the Oracle usernames and passwords at a later time. To create the users, open the Oracle Enterprise Manager for the database in a web browser.
Installing or Upgrading the System Reporter Tools You have several options for installing the HP 3PAR System Reporter tools, depending on whether you choose to use the SQLite database (the default), or one of the other optional databases.
a. b. c. d. If you selected SQLite for the database, you are prompted for the installation directory for the HP 3PAR Reporting Tools SQLite database. Use the Browse... button to select and enter the directory or accept the default directory (C:/Program Files/3PAR/System Reporter/inservstats) and then click Next. Since SQLite databases are merely on local files no user name or password are required and you will skip step 8 and be taken directly to step 9.
NOTE: In addition to configuring the SMTP parameters for alerts, it is also used for sending an email when the If there is a problem with sampling, send email to this address option is set through the Sampling Policies settings. NOTE: Some firewalls or antivirus software may prevent the HP 3PAR System Reporter sampler service (an executable named sampleloop.exe) or the facility for sending email links for reports (an executable named inserv_perf.exe) from connecting to the SMTP server.
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 to install the System Reporter web server code. Both these packages must be installed after logging in to a terminal session on the server as the root user.
6. Install the sysrptwebsrv package by mounting the System Reporter CD, changing to the directory on the CD that includes the rpm packages and running: rpm --install sysrptwebsrv-3.1-1.i386.rpm 7. Edit the /var/www/cgi-bin/3par-rpts/config.tcl and /var/www/cgi-bin/ 3par-policy/config.tcl files following the directions in those files. If previous versions of the file were saved, you may keep the previous settings and simply replace the files with the saved versions.
• Days to keep Daily Data -- Specifies the number of days to retain daily data. • Days to keep Adaptive Optimization Data -- Specifies the number of days to retain Adaptive Optimization data. 10. Click Submit Query. NOTE: Since performance data for LDs can increase the database size substantially you should check the Skip LD Performance data box unless you intend to configure Adaptive Optimization for the system.
The HP 3PAR System Reporter Excel client is contained in a single Microsoft Excel workbook with the file name 3PAR System Reporter.xls. After downloading this file, you can save it in any convenient location. To download the HP 3PAR System Reporter Excel client: 1. Open a browser window and point it at http:///3par/ where is the server where Apache HTTP Server is installed (see “Before You Begin” (page 23) and “Optional Components” (page 28). 2.
file, you must also create a password file {password_file}, as described in your Apache documentation.
7. 8. 9. Locate and remove the inservstats.db file if the file was in a location other than the System Reporter folder. Also remove the file inservstats.db-journal if present in the same folder. (Optional) In the location where you installed Apache HTTP Server, locate the htdocs directory (for example, C:\Program Files\Apache Group\Apache2\htdocs) and delete the 3par subdirectory (C:\Program Files\Apache Group\Apache2\htdocs\3par).
3 Getting Started You can use 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 utilization with the optional Adaptive Optimization feature, see “Configuring the System Reporter Policy Settings” (page 113).
Figure 14 The System Reporter Main Window The HP 3PAR System Reporter Main Menu (Figure 14 (page 52)) is divided into the following areas: 52 • Title Pane, which shows the version of System Reporter. • Main Menu tabs, which provide options for generating quick reports, accessing scheduled reports and creating customized reports. (See “Accessing and Creating Reports” (page 63) for details). • Extras Menu area has links to: ◦ Excel Client, used to create and access custom reports.
◦ User Guide (this document in PDF format). ◦ Sampling Status (the time since the most recent high-resolution sample for each system being sampled). NOTE: Instead of opening a new window, browsers can be configured to open a new tab instead. For Firefox, open the options window (Tools→Options), click the Tabs tab, and select the option that opens new pages in a new tab.
The list of available objects can be filtered by typing an expression pattern in the text input area above the list of available objects and clicking on the Filter button. CAUTION: Filtering large numbers of objects may exceed the limit for your server, in which case you should reduce the number of objects being filtered and try again.
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 settings depending on the version of Excel that you are using. Setting the Security for Excel 2003 In most cases, when accessing the System Reporter client for Excel 2003, a Security Warning screen appears indicating that macros have been disabled (Figure 16 (page 55)).
Figure 17 Setting the Security Level 3. On 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 level setting, close the Excel workbook and then reopen it.
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. 3. Choose the Enable this content radio button. Click OK. If you do not see a Security Warning when accessing the Excel client, it is likely that the main Excel Macro Settings are not set up properly and need to be changed. In this case, follow these steps: 4. 5. 6. 7.
Figure 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 signed macros. 9. Click OK, then click OK again to return to the System Reporter Excel client main screen. 10. Close the Excel client, then launch it again from the System Reporter main menu. 11.
1. After opening the HP 3PAR System Reporter Excel client workbook with the correct security level setting, click Initialize. The Connection Parameters dialog box appears (Figure 20 (page 59)). Figure 20 Connection Parameters Dialog Box 2. In the Server Hostname box, type a host name and click OK. The host 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 23)).
Changing the Excel Client Server and Resetting the Workbook The HP 3PAR System Reporter Excel client workbook includes a custom 3PAR menu that is accessible from the Microsoft Excel menu tab called Add-Ins. This menu tab enables you to change the Web server, reset the workbook, and delete menu sheets. Changing the Web Server To change the Web server used for querying the System Reporter database: 1. Click the Add-Ins menu tab, choose the 3PAR pull down menu, and then select Set server name....
Deleting Data Sheets Data sheets remain until you manually delete them. Manually deleting a data sheet causes any embedded charts associated with that data sheet to disappear as well. To delete a data sheet: 1. At the bottom of the Microsoft Excel window, click a data sheet tab to enable the sheet to be deleted. 2. Point to the name of the data sheet tab and then right-click. 3. On the shortcut menu that appears, click Delete. 4. In the confirmation dialog that appears, click OK. The data sheet is deleted.
Figure 22 Security Alerts Multiple Issues To enable macros 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).
4 Accessing and Creating Reports System Reporter provides quick reports, scheduled reports, and custom reports that are specifically tailored for your operating environment. The menu selections and controls available for creating custom reports from either the web interface or the Excel client are functionally identical, so the information in this chapter applies to both with explanations provided for any minor variations.
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 when the report is scheduled. Each time the report runs, a new subdirectory is created for that instance of the report using the timestamp as the name.
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 web interface and Excel client for creating custom reports are identical except that the Excel client charting functions are accessed separately from the main interface and provide some additional flexibility.
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 The first step in creating a report is to choose the appropriate options for the type of report that you want to generate.
Sample Resolution The Sample resolution control enables you to select from one of three resolutions corresponding to the tables that are maintained in the database (see Table 6 (page 67)). The samples can be retained for different lengths of time for each resolution (see “Editing Sampling Policies” (page 115) for instructions on altering the default sampling policies).
Table 7 Reports and Uses (continued) Reports Purpose Link Performance Display performance of links between nodes. See “Link Performance Reports” (page 111) for the types of statistics provided by this report. Adaptive Optimization Display Adaptive Optimization reports. See “Adaptive Optimization Reports” (page 112) for the types of statistics provided by this report.
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 sections: • 1. Report Selection: controls the type of report that will be generated, see “Report Selection” (page 75). • 2.
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 numbers of objects may exceed the limit for your server, in which case you should reduce the number of objects being filtered and try again.
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 control is not valid for report. • A Y entry indicates that the control is valid for all report types. • A T entry indicates that the control is valid for the report but only for Versus Time report types.
Table 10 Controls for Each Report Report: Summay r PD CPG LD Section and Space Space Space Control VV PD Space Perf Port Perf LD Perf VLUN Perf VV Node CPU Cache Cache Perf Perf Perf Link Perf Adaptive Optimization Main Menu “Sample Y Resolution” (page 67) Y Y Y Y Y Y Y Y Y Y Y Y Y “Select Systems” (page 68) Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y “Select Domains” (page 68) Y Report Selection “Standard Report Types” (page 75) Y Y Y Y Y Y “Compa
Table 10 Controls for Each Report (continued) Report: Summay r PD CPG LD Section and Space Space Space Control VV PD Space Perf Port Perf LD Perf VLUN Perf VV Node CPU Cache Cache Perf Perf Perf Link Perf Adaptive Optimization “End Time” (page 85) T T T T T T T T H H H H T T T “Count” (page 85) Y T Object Selection “Select PDIDs” (page 86) Y Y “Include Chunklets” (page 86) Y Y “Select Cage IDs” (page 86) Y Y “Select Disk Types” (page 86) Y Y “Select Disk Speed” (page 8
Table 10 Controls for Each Report (continued) Report: Summay r PD CPG LD Section and Space Space Space Control VV PD Space Perf “Select VVs” (page 89) Y “Select Prov Types” (page 89) Y “Select VV Types” (page 90) Y Port Perf “Select Hosts” (page 91) Y “Select Port Types” (page 90) Y “Select Port Types” (page 90) Y “Select Port Rates” (page 90) LD Perf Y VLUN Perf VV Node CPU Cache Cache Perf Perf Perf Y Y Link Perf Adaptive Optimization Y Y “Select Ports (n:s:p)” (page 90) “Select
Table 10 Controls for Each Report (continued) Report: Summay r PD CPG LD Section and Space Space Space Control VV PD Space Perf Port Perf LD Perf VLUN Perf VV Node CPU Cache Cache Perf Perf Perf Link Perf Adaptive Optimization “Chart Y Pixels” (page 97) Y Y Y Y Y Y Y Y Y Y Y Y Y “Time Labels” (page 97) T T T T T T T T T T T T “Legend Position” (page 97) Y Y Y Y Y Y Y Y Y Y Y Y “Time Format” (page 97) T T T T T T T T T T T T “Select Space Unit” (pa
Table 11 Standard Report Types (continued) Report Type Purpose Unless the Compare control is available and set to something other than none, the Versus Time report shows aggregate metrics for all the selected objects over a range of time. See Figure 28 (page 77) for an example. If the Compare control (see “Compare” (page 81)) is set to a specific object, then the Versus Time report plots the metrics separately for each of up to 16 of the objects so that they can be compared.
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.
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) shows an example where systems are being compared.
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 and IOPs/s selected in the Order By control. This allows us to easily compare the performance of hosts on different systems.
Figure 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.
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 Summary Columns This control is valid only for the Summary report and selects which columns are displayed in the Summary report. Compare This control is only valid for some Versus Time performance reports and the options available depend on the report.
Max. Number Specifies the maximum number of graphs that will be generated for a given report. This option is only valid when a compare is requested and when set to none, this option is ignored. Select Peak For some reports, when the number of objects to be compared (see “Compare” (page 81)) exceeds 16, the Select Peak control can be used to select which 16 objects to compare.
Order By This control is only valid for At Time reports and specifies the order of the X (category) axis for the reports. The menu options available depend on the report selected and are listed with each report. One or more Order By options can be selected (use CTRL-CLICK to select multiple options) and the default if none are selected is System. See Table 13 (page 83) for a listing of all available options. Table 13 Order By Option Purpose System Order by HP 3PAR StoreServ Storage.
Table 13 Order By (continued) Option Purpose Queue Length Order by queue length. Busy Percentage Order by the percentage of time that the VLUN is busy (i.e., has at least one outstanding IO operation). Total Accesses Order by total number of accesses for VV 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 performance. Idle Order by Idle time for CPU performance reports.
Table 14 Begin/At Time Option Purpose earliest Begin with the earliest sample available. a list of specific time values Begin at the specified time value. The values in the menu are populated based on the actual samples in the selected data table. a list of relative time values Begin at the specified time before the current time.
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 Purpose -All PDIDs- The report will include all the PDIDs that are included in the database. list of specific PDIDs Select one or more PDIDs to include in the report.
Table 21 Select Disk Speed Option Purpose -All Disk Speeds- The report will include all the Disk Speeds that are included in the database. list of specific Disk Speeds. Select one or more Disk Speeds to include in the report. Multiple Disk Speeds can be selected using (CTRL-CLICK). Currently available disk speeds are: • 10- 10 K RPM disks • 7- 7200 RPM disks • 15 - 15 K RPM disks • 150 - SSDs Include PDs in States This control is only available for PD Space reports.
Table 24 Select Snp CPGs Option Purpose -All CPGs- The report will include all the Snp CPGs that are included in the database. list of specific CPGs 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 “Filtered Multi-Selection Control” (page 53)) used to select one or more CPGs to include in the report. This control is available for CPG Space, LD Space, and Adaptive Optimization Region IO Density reports.
Table 28 Select LD Usage (continued) Option Purpose C,SA: Copy Snapshot Admin Include LDs mapped to VV snapshot copy admin space. P: Preserved data Include LDs that are marked to hold data that cannot be flushed due to RAID set failure. P,F: First Preserved data Include Preserved data LDs that are also distinguished as being the first in the group of Preserved data LDs. log: Logging Include LDs that are marked for use in temporarily storing data during physical disk replacement operation.
Table 31 Select Prov Types (continued) Option Purpose • tpsd - Old-style thin provisioned VV (created with an older release than 2.3.1) where both the base VV space and the snapshot copy space are allocated from the same Snp space associated with the same Snp CPG. • snp - The VV is a virtual copy (snapshot). Select VV Types This control is available for VV Space reports and is used to select the copy type of the VV.
Table 35 Select Ports (n:s:p) Option Purpose -All Ports- The report will include all the Ports that are included in the database. list of specific ports Select one or more ports to include in the report. Multiple ports can be selected using (CTRL-CLICK).
Format Selection (Web interface only) The format selection controls are used to specify how the output of a given report is formatted for presentation.
providing you are using a browser that supports html5 canvas tags (the latest versions of Windows IE9, Firefox, and Google Chrome browsers currently offer this support). Chart Types Stacked charts stack data on top of each other so you can also see totals. However, since the total height of the stacked charts (with Stacked Bars, Stacked Vert Bars andStacked Area charts) is the sum of the individual segments, they are not suitable for some forms of data.
You can choose from the following chart types: • Stacked Bars Figure 34 Chart Using Stacked Bars • 94 Stacked Vert Bars Accessing and Creating Reports
Figure 35 Chart Using Stacked Vertical Bars • Stacked Area Figure 36 Chart Using Stacked Areas • Lines Creating Custom Reports 95
Figure 37 Chart Using Lines • Bars Figure 38 Chart Using Bars 96 Accessing and Creating Reports
• Vert Bars Figure 39 Chart Using Vert Bars Chart X Pixels You can explicitly specify the length in pixels of the X (category) axis of charts. If this is left blank the X axis length will be automatically chosen. If the length specified is too small, the chart may not be drawn. Chart Y Pixels You can explicitly specify the length in pixels of the Y (value) axis of charts. If this is left blank the Y-axis length will be automatically chosen.
Table 41 Time Format Option Purpose Auto Time format is chosen automatically based on the sample resolution. If resolution is Daily, the format includes the month, date, hours and minutes, for example: 11-29 08:32. If the resolution is hourly, the format includes the date, hours and minutes, for example: 29 08:32. If the resolution is High-Res, the format include date, hours, minutes and seconds, for example: 29 08:32:05.
Figure 40 Change Chart Type Menu for the Excel Client 4. 5. Choose the appropriate selection from the list of chart types, then select on the chart that you want to use to display the report data. Click OK. CAUTION: The Excel Chart controls are configured for the default Chart Type. If you change the default Chart Type, you may also need to modify other chart controls for optimal viewing.
1. Right-click in any data cell and click Data Range Properties in the shortcut menu that appears. Figure 41 Data Range Properties Shortcut Menu The External Data Range Properties dialog box appears. 2. Select the Refresh every checkbox and enter the desired value. Figure 42 External Data Range Properties Dialog Box 3. Click OK.
It is also possible to retain a chart for further reference. This can be done by moving the 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 a chart for further reference 1. On the chart to be retained, right-click to bring up the shortcut menu. 2. On the shortcut menu, click Location (for Excel 2003) or Move Chart (for Excel 2007).
NOTE: The Visual Basic code for the Excel client is password protected to prevent accidental modification. For customers who would like to add their own code, the password is “password”. Please observe caution when considering using another password other than the default, since subsequent access would not be possible if knowledge of the altered password were to become unavailable for some reason.
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 (header cell and all data cells) and then CTRL-CLICK and drag to select the Percent spare used column. 2. On the Microsoft Excel 2003 main menu, click Insert and then Chart to bring up the Chart Wizard. 3. Use the chart wizard to create a new chart. a.
5 Interpreting Report Metrics Summary Report Figure 43 (page 104) shows a typical example of the metrics that are provided by a Summary Report. Figure 43 Summary Report Metrics Table 43 (page 104) describes all of the metrics available for Summary Reports. Only some of the metrics described here are shown by default, the others depend on which columns are selected through the Select Summary Columns control (see “Select Summary Columns” (page 81)).
Table 43 Summary Report Metrics (continued) Metric Description FC Host Ports Number of host ports. iSCSI Host Ports Number of iSCSI host ports. Disk Ports Number of disk ports. RCIP Ports Number of RCIP ports. RCFC Ports Number of RCFC ports. Free Ports Number of free ports. FC 15K RPM PDs Number of FC 15K physical disks. FC 10K RPM PDs Number of FC 10K physical disks. NL 7K RPM PDs Number of 7K near line physical disks. SSD PDs Number of 150 SSD physical disks.
Table 43 Summary Report Metrics (continued) Metric Description Shown by default. Used PD Capacity GiB Used PD space. Total PD Capacity GiB 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), (NL 7k), (SSD) Used space for a specified drive type in GIBs. RPM PD Capacity GiB Total (FC 10,15K), (NL 7k), (SSD) Total space for a specified drive type in GIBs.
Space Reports This section describes the metrics that 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 the usage types shown in Table 44 (page 107).
Table 45 CPG Space Usage Types (continued) Usage Type Description Admin Free Space GiB Amount of admin free space available for CPG allocation. Snap Free Space GiB Amount of raw snap space available for CPG allocation. User Free Space GiB Amount of user free space available for CPG allocation. Total Free Space GiB Total amount of free space available for CPG allocation. Admin Space GiB Amount of remaining Admin space available for currently allocated CPGs.
Table 47 VV Space Report Metrics (continued) Metric Description Snap Rsvd Space Space that is reserved for Snap Space for the selected VVs (Snap Used Space + Snap Free Space). This is zero for Virtual Copy (snapshot) VVs. Snap Vcopy Space Snap Space used by Virtual Copy (snapshot) VVs only. This is zero for all VVs that are not Virtual Copies (snapshots). Note that this value is calculated on the HP 3PAR StoreServ Storage by running the updatesnapspace command.
Table 48 Performance Metrics for PD, Port, LD and VLUN Performance Reports (continued) Metric Description Total Svct ms Average total (read + write) service time in millisec. Read IOSz KBytes Average size of read operations in KBytes. Write IOSz KBytes Average size of write operations in KBytes. Total IOSz KBytes Average size of read and write operations in KBytes. Queue Length Queue length at the sample time.
Table 50 Node Cache Performance Report Metrics Metric Description Read Hits Number of reads that hit in the cache. Read Misses Number of reads that miss in the cache. Read Total Total number of reads. Not shown in charts. Write Hits Number of writes for which the page is already in cache AND is dirty (i.e., has previously written data that has not yet been flushed to disk). Write Misses Number of writes that miss in the cache.
Table 52 Link Performance Report Metrics Metric Description Transfers/s Transfers per second on the link. Bandwidth Bandwidth used on the link. Transfer size Average size of the transfers on the link. Adaptive Optimization Reports Table 53 (page 112) describes the metrics that are shown for Adaptive Optimization Reports. Table 53 Adaptive Optimization Report Metrics Metric Description IO Rate Density Shows IO rate density for a given region.
6 Configuring the System Reporter Policy Settings System Reporter enables you to edit HP 3PAR System Reporter policies, such as the sampling policies, add or remove storage servers from the database, and schedule reports. These actions can only be performed using a Web browser and cannot be performed using the System Reporter Excel client. The end of the chapter also describes how to edit the Apache HTTP Server configuration files, which hold the Apache HTTP Server usernames and passwords.
Table 54 Sampling Policies (continued) Policy Default Default number of hours to keep hi-res samples (in force by default for all systems 24 unless specified otherwise on an individual basis) Default number of days to keep hourly samples (in force by default for all systems 7 unless specified otherwise on an individual basis) Default number of days to keep Adaptive Optimization hourly samples (in force 7 by default for all systems unless specified otherwise on an individual basis) Default number of days t
} ) NOTE: Please note that System Reporter does not 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 System Reporter Web server scripts are installed. The 3PAR System Reporter window appears. 2. 3. In the Extras Menu area, select Policy Settings.
Figure 46 Connection Dialog Box NOTE: See “About Apache HTTP Server Authorization and Access Control” (page 48) for more instructions on setting Apache HTTP Server to require a username and password in order to edit sampling policies. 6. In the New Value box, type a new value and then click Submit Query. The Sampling Policies window appears with the new value. 7. When finished editing policies, close the Sampling Policies window.
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 appears. 3. 4. 5. 6. 7. Choose the InServ Systems tab. Click Remove InServ. Choose the storage server from the drop-down list and then click Submit Query. An alert window appears confirming that the system was removed.
Configuring Rules for Email Alerts System Reporter can be configured to evaluate numerous rules and generate email alerts to specified recipients for each rule whose conditions are met. Adding an Alert Rule To add 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 3PAR System Reporter Policies window appears. 3.
7. 8. An alert window appears confirming that the alert rule has been changed. Click OK to return to the Sampling Policies window. Removing an Alert Rule To remove 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 3PAR System Reporter Policies window appears. 3. 4. 5. 6. 7. 8. Choose the Alert Rules tab.
Table 55 Data Table (continued) Data Table Description statpd_fc15sum Represents the aggregation of all the FC 15K RPM PDs in 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 Logical Disk performance table. statvlun VLUN performance table. statcpu CPU performance table. Resolution The resolution of data table on which the rule operates.
Table 57 Metric (continued) Metrics Description Data Tables statpd_fc10sum, statpd_fc15sum, statpd_ssd150sum, statld, statvlun write_kbps Write KBytes/sec statport, statport_nodesum, statport_syssum, statpd, statpd_nl7, statpd_fc10, statpd_fc15, statpd_ssd150, statpd_sum, statpd_nl7sum,statpd_fc10sum, statpd_fc15sum,statpd_ssd150sum, statld, statvlun total_kbps Total (read + write) KBytes/sec statport, statport_nodesum, statport_syssum, statpd, statpd_nl7, statpd_fc10, statpd_fc15, statpd_ssd150, st
Condition Value Specifies the condition value. Recipient Email address to which the alert email should be sent. Example of an Alert Rule Figure 47 (page 122) shows an example of a configured alert. In this example, System Reporter will send an email alert to email@address each time 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).
Scheduled reports offer the following advantages: • Allows quick access to pre-configured reports on a scheduled basis instead of keeping active tabs in a web browser. • Allows the generation of reports to take place in the background at off-peak times to minimize impact on system performance. • Allows distribution of scheduled reports to users from a selected directory without giving access to policy configuration or system information outside a particular users authority.
9. 10. 11. 12. 13. Choose whether or not the report should be currently active or not (true/false). This option allows you to turn the report generation on and off as needed. Specify the number of days to retain a scheduled report. System Reporter will automatically delete reports that are older then the specified number of days. The default is seven days. If appropriate, enter an email address specifying where a link should be sent when the scheduled report is generated. When done, click Submit Query.
NOTE: For complete details on how to configure and use Adaptive Optimization, see “Using Adaptive Optimization” (page 180). About File Permissions The files installed or created by the HP 3PAR System Reporter installer have default permissions that allow any user to read file contents. Use the appropriate Windows or Linux security mechanisms to limit file access as desired.
2. 3. In the 3par-policy subdirectory, locate the config.tclfile (for example, C:\Program Files\Apache Software Foundation\Apache2.2\cgi-bin\3par-policy\ config.tcl) and open with a text editor. At the bottom of the file, alter the appropriate fields as necessary.
7 Web Queries About Web Queries System Reporter Web queries to the System Reporter Web server have the following basic format: http:///cgi-bin/3par-rpts/ inserv_perf.exe?report=[&
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 product when it is released. The Product version number is not necessarily related to the ReportData version.
Report Options Options are included in the query URL by using the following syntax: = where and are the options and values described below. category Use the category option to specify which database table to use when pulling results. This option can only be specified once in a given query string. NOTE: The System Reporter maintains three database tables that each offer a different granularity of resolution and stored time range. See also “Sample Resolution” (page 67).
DiskType Compares selected disk types. This value is only available for the pd_perf_time, ld_space_time and pd_space_time reports. DiskSpeed Compares selected disk speeds. This value is only available for the pd_perf_time and pd_space_time reports. RaidType Compares selected RAID types. This value is only available for the ld_space_time report. n:s:p Compares selected port positions. For this value, an escape sequence may be required to retain spacing and special characters (for example: n%3As%3Ap).
Compares selected disk magazine position. This value is only available for the pd_space_time report. example: The following example specifies that all logical disks are compared: &compare=LD comparesel When the compare option (see “compare” (page 129)) is used, up to 16 objects can be compared. However, if there are more than 16 objects selected, then the comparesel option is used to select a metric. The 16 objects with the highest peak values of the metric are chosen to be compared.
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 Returns values from the ldspace database tables. pdspace Returns values from the pdspace database tables. vvspace Returns values from the vvspace database tables. statpd Returns values from the statpd database tables.
example: The following example specifies that the report is to be reloaded every 2 minutes: &refresh=2 charttab Use the charttab option to specify whether to post the results in tabular format, as charts, or both. The number of charts and/or tables used to post the results depend on the report type. This option can only be specified once in a given query string. values: Specify one of the following: chart Specifies that results will be displayed in the form of one or more charts.
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 Figure 36 (page 95) for an example of a chart using stacked areas. bars (Default). Specifies that bar charts will be used. See Figure 38 (page 96) for an example of a bar chart.
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 legend is placed to the right of the chart. example: The following example specifies that the chart legend should be to the right of the chart.
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 string.
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 time. NOTE: You can use the sample_times report (see “sample_times” (page 178)sample_times on page 8.78 ) to see tsecs values paired with times expressed using an easier-to-read format.
Domain Group results by domain. Host Group results by hosts. CPG Group results by Common Provisioning Group (CPG) name. UsrCPG Group results by Common Provisioning Group (CPG) name for the User Space of VVs. SnpCPG Group results by Common Provisioning Group (CPG) name for the Snap Space of VVs. VV Group results by Virtual Volume (VV) name. VVType Group results by Virtual Volume (VV) Type. ProvType Group results by virtual volume (VV) provisioning type. LD Group results by Logical Disk (LD) name.
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 the orderby option to determine how to order results. The orderby option can be used multiple times in the same query string.
PortNode Order results by port node number (The n part in n:s:p). RaidType Order results by RAID level (for example, RAID 0, RAID1, RAID 5 and RAID 6). LDUsage Order results by logical disk usage. See Table 28 (page 88) for a list of these usage types. DiskType Order results by physical disk type. DiskSpeed Order results by physical disk speed. CageID Order results by drive cage ID number. Mag Order results by magazine position within the drive cage (0 through 7).
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. LDRawSize Order results by total raw LD size. TotalAccesses Order results by total number of accesses to the VV. ReadHit% Order results by total read hit percentage to the VV.
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 following: MiB (2^20 bytes) (Default). Use megabytes (1,048,576 bytes) as the logical disk space unit.
See “ldspaceunit” (page 142). GiB (2^30 bytes) See “ldspaceunit” (page 142).
value: Specify one or more of the following: --All cage IDs-(Default). Does not exclude cages based on their cage IDs. This value consists of a drive cage ID.
SPR_AVAIL_FAIL Include only spare available (unused) chunklets that have failed.
seldisktype Use the seldisktype option to select a disk type. value: Specify one or more of 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 type disks. NL This value allows you to include only Near Line type disks.
seldomain Use the seldomain option to select a domain according to the domain name. value: Specify one or more of the following: --ALL Domains-(Default). Does not exclude any domain based on domain names. This value consists of a storage server domain name.
The following example specifies including only VLUNs exported to host winhost1 or winhost2: &selhost=winhost1&selhost=winhost2 selld Use the selld option to 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 includes logical disks of all usage types: &sellduse= The following example specifies only logging logical disks: &sellduse=log selnode Use the selnode option to select controller nodes according to their numbers (0-7). value: Specify one or more of the following: --All Nodes-(Default). Specifies that nodes are not to be excluded based on their names. This value consists of a controller node number (value is an integer between 0 and 7).
example: The following example shows two ways to specify that no ports are to be excluded based on location: &selnsp= OR &selnsp=--All%20Ports-- The following example specifies that only port 0:1:1 will be included: &selnsp=0%3A1%3A1 selpdid Use the selpdid option to select physical disks according to the physical disk ID. value: Specify one or more of the following: --ALL PDIDs-(Default). Do not exclude PDs based on their ID number. This value consists of a physical disk ID number.
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 used: &selpdstate=Not%20valid selporttype Use the selporttype option to select ports according to their type. values: Specify one or more of the following: --All Port Types-(Default). All port types are selected.
Specify this value to include RAID 1 logical disks. 5 Specify this value to include RAID 5 logical disks. 6 Specify this value to include RAID 6 logical disks. example: The following example specifies inclusion of all logical disks regardless of RAID level: &selraidtype= The following example includes RAID 1 and RAID 5 logical disks only: &selraidtype=1&selraidtype=5 selsys Use the selsys option to select a particular storage system. values: Specify one or more of the following: --All Systems-(Default).
example: The following example shows two ways to specify that volumes be included regardless of name: &selvv= OR &selvv=--All%20VVs-- The following example includes volumes with names vol1, vol2, and vol3 only: &selvv=vol1&selvv=vol2&selvv=vol3 selvvtype Use the selvvtype option to specify virtual volumes according to their types. values: Specify one or more of the following: --All VV Types-(Default). Does not exclude virtual volumes based on their types. base Select base VVs.
Chartlib dynamic chartlib=rgraph Allows you to toggle between static chart and dynamic (experimental) chart. static (default) chartlib=gdgraph Allows you to toggle between static chart and dynamic (experimental) chart. Maxgraph Specifies the number of objects that are displayed on the graph. The default value is 8 and the maximum value is 16.
Space Reports pd_space_time Plots the total number of chunklets of different types summed over the specified systems and PDs over a period of time (x-axis). Can show the rate of usage of raw space. example: The following example shows the entire query string for a pd_space_time report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.
selcpg=--All%20CPGs--&selld=--All%20LDs--&selraidtype=& seldisktype=--All%20Disk%20Types--&sellduse=&groupby=System&orderby=System& report=ld_space_group vv_space_time Plots the virtual size as well as raw and LD space used by the user, snap, and admin (on y-axis) versus time (on the x-axis). For the LD space, it separates 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.
example: The following example shows the entire query string for a vv_space_group report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& vvspaceunit=MiB%20%282%5E20%20bytes%29&selsys=--All%20Systems--& selcpg=--All%20CPGs--&selvv=--All%20VVs--&groupby=System& orderby=System&report=vv_space_group Performance Reports Performance reports show information about physical disk, logical disk, port, VLUN (export), VV cache, and CPU performance.
selsys=--All%20Systems--&selpdid=--All%20PDIDs--&selnsp=--All%20Ports-&histbegin=1&report=pd_svt_hist pd_svt_histvstime Plots the service time histogram of all the physical disks in the selected systems versus time. example: The following example shows the entire query string for a pd_svt_histvstime report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.
example: The following example shows the entire query string for a port_svt_hist report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?category=daily&charttab=chart&charttype=stackedbars&refresh=&begin tsecs=&histbegin=&selsys=--All%20Systems--&selporttype=--All%20Port%20Types-&selnsp=--All%20Ports--&report=port_svt_hist port_svt_histvstime Plots the service time histogram of all the ports in the selected systems versus time.
example: The following example shows the entire query string 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 the selected systems versus time.
example: The following example shows the entire query string for a vlun_svt_hist report: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?charttab=chart&charttype=stackedbars&category=daily&begintsecs=& selsys=--All%20Systems--&selhost=--All%20Hosts--&selvv=--All%20VVs--& selnsp=--All%20Ports--&histbegin=1&report=vlun_svt_hist vlun_svt_histvstime Plots the service time histogram of all the VLUNs (exports) in the selected systems versus time.
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=chart&charttype=stackedbars&category=daily&begintsecs=& endtsecs=&timeform=absolute&selsys=--All%20Systems--&selnode=--All%20Nodes--& report=cpu_perf_time cpu_perf_group Plots the CPU performance metrics in the selected systems and nodes at a specific time, grouped by system and/or node.
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 summary and space report and lists the options that are valid for performance reports. An entry can be: • blank: Indicates that the option is not valid for the report.
Figure 51 Valid Options for Summary, Space and Adaptive Optimization Reports (I) 164 Web Queries
Figure 52 Valid Options for Summary, Space and Adaptive Optimization Reports (II) Options Available by Report 165
Figure 53 Valid Options for Summary, Space and Adaptive Optimization Reports (III) Figure 54 Valid Options for Performance Reports (I) 166 Web Queries
Figure 55 Valid Options for Performance Reports (II) Options Available by Report 167
Figure 56 Valid Options for Performance Reports (III) Figure 57 Valid Options for Performance Reports (IV) 168 Web Queries
Objects Present Reports Objects present reports return the objects present in a table over a specified time for use in user interface controls. For example, to allow the user to select a display of PD space usage at a particular time, you would need to know which times, systems, and PD IDs are present in a table. Sort order of columns is ascending, starting with the left column, then the next to the right, and so on.
Table 58 Objects Present Report table values (continued) Report table values objects_present&“objectpres= host_name” (page 173)objectpres= host_name on page 8.69 statvlun objects_present&“objectpres= ld_name” (page 173)objectpres= ld_name on page 8.70 ldspacestatld objects_present&“objectpres=node” (page 174)objectpres=node on page 8.71 statcpu objects_present&“objectpres=pdid” (page 174)objectpres=pdid on page 8.
objectpres= cpg_name Returns a list of common provisioning group (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 on each system. Output columns are: • System: the system name • CPG: common provisioning group name.
objects_present&objectpres=diskspeed http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=diskspeed&table=statpd& category=daily output: Returns a row for each disk speed on each system. Output columns are: • System: the system name • DiskSpeed: list of disk speed objectpres= disktype Returns 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.
output: Returns a row for each domain present over the time range on each system. Output columns are: • System: the system name • Domain: domain names objectpres= host_name Returns a list 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.
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 names The following is example output of the query: objectpres=node Returns a list of controller node numbers. example: The following example shows the entire query string for: objects_present&objectpres=node http://localhost/cgi-bin/3par-rpts/ inserv_perf.
example: The following example shows the entire query string for: objects_present&objectpres=pdid: http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=pdid&table=pdspace& category=daily output: Returns a row for each physical disk present over the time range for each system. Output columns are: • System: the system name • PDID: physical disk ID numbers The following is example output of the query: objectpres=port Returns a list of ports.
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 row for each system present over the time range for each system.
Output columns are: • System: system name • VV: virtual volume names The following is example output of the query: objectpres= vv_name_nosnap Returns a list of virtual volume names, excluding snapshot 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.
example: The following example shows the entire query string for: objects_present&objectpres=porttype http://localhost/cgi-bin/3par-rpts/ inserv_perf.exe?report=objects_present&objectpres=porttype&table=statport& category=daily output: Returns a row for each time sample in the given table for the given category (resolution). Output columns are: • System: system name • Port Types: port type The following is example output of the query: sample_times Returns valid times of database samples.
Objects Present Reports 179
8 Using Adaptive Optimization If you have an Adaptive Optimization license, you can use the Adaptive Optimization feature in conjunction with System Reporter to optimize storage utilization across multiple tiers. NOTE: Adaptive Optimization in System Reporter 3.1 is 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 OS.
Selecting an HP 3PAR StoreServ Storage 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. To change the configuration, click the InServ Systems tab in the System Reporter Policies window.
3. Click the Adaptive Optimization tab. The Adaptive Optimization Configuration window appears (Figure 60 (page 182)). Figure 60 Adaptive Optimization Configuration Main Window The following information is provided for each Adaptive Optimization configuration: • Id -- A unique identification number assigned automatically to the configuration when it is created. • InServ -- Name of the HP 3PAR StoreServ Storage for which the configuration is implemented.
NOTE: When you specify two tiers, for the purposes of analysis and data movement only the order of the tiers matters, not the actual tier number. For example specifying tiers 0 and 1 is equivalent to specifying 0 and 2 or 1 and 2. The lower numbered tier is considered the faster tier and the higher numbered tier is considered the slower tier.
except in the case where the CPG is the default for snapshot or base TPVV allocation as noted in the following caution. CAUTION: For some CPGs, especially those that use small PDs such as SSDs, the additional buffer space in the CPG may be too large to be left unused. To minimize the buffer space you can use the CLI to set the CPG grow size to the smallest possible value.
not be optimal. We can achieve optimal results by scheduling adaptive optimization execution for 11 am Monday through Friday with a measurement interval of 3 or 4 hours. That way only performance measurements during the important period for the application will be considered. NOTE: The measurement hours selected should not exceed the retention time for adaptive optimization samples set in the sampling policies (see “Editing Sampling Policies” (page 115)).
9. Choose whether the configuration is to be currently active (true/false). This switch allows you to turn the optimization off and on as required. 10. When done, click Submit Query. An alert window appears confirming that Adaptive Optimization configuration has been added. 11. Click OK to return to the Sampling Policies window. Changing an Adaptive Optimization Configuration To change an Adaptive Optimization configuration: 1.
Figure 61 Region IO 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 the histogram bucket, and the Y-axis (value) for the second chart is the total IO accesses/min for the regions in the histogram bucket.
Figure 63 Region IO Density without Adaptive Optimization You can see that much of the space is used for regions with very few IO accesses and that most of the IO accesses are handled by a very small number of regions. Adaptive Optimization would work very well in this situation since the busiest regions would be moved to the fastest tier and the most idle regions would be moved to the slowest tier.
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 overhead for Adaptive Optimization since it takes system resources and disk bandwidth to move data between tiers.
report shows the space moved over the selected time interval for each Adaptive Optimization configuration. The showvvcpg CLI extension Adaptive Optimization may move regions of a VV into different CPGs. In order to more easily see how much of each VV is in each tier, the CD for System Reporter 3.1 includes a CLI script file, showvvcpg.tcl, that adds a new CLI command when it is sourced from the CLI. Once you start the CLI and connect to the HP 3PAR StoreServ Storage array, you can source the showvvcpg.
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 - - - - esx-rdm-dev-oracle esx-fc-r1 384 1024 78848 - - esx-rdm-dev-oracle esx-ssd-r1 128 - 7168 - - esx-rdm-sysreporterfield esx-fc-r1 320 - 470400 - - esx-rdm-sysreporterfield esx-ssd-r1 448 - 896 - - --------------
9 Database Schema Using The Database Schema The description of the database schema is provided as a convenience to those wishing to query the database directly instead of using the web queries described in “Web Queries” (page 127).
Table 60 sampleinserv_5 Table Column Type Comment name VARCHAR(64) NOT NULL IP address of the system to sample. usessl INTEGER NOT NULL Determines whether CLI connections to the HP 3PAR StoreServ Storage will use SSL. 0 - Do not use SSL 1 - Use SSL cliport INTEGER NOT NULL Currently unused. In future this will be used to explicitly specify the port number to use for the CLI connection to the system.
Table 61 system_4 Table (continued) Column Type Comment system_model VARCHAR(32) NOT NULL System hardware model, for example: InServ S400X InServ T400 CHSIZEMB INTEGER NOT NULL Indicates the chunklet size. The alertconfig Table The alertconfig_2 table contains a row for each alert configuration rule. Table 62 alertconfig_2 Table Column Type Comment alertid INTEGER PRIMARY KEY (AUTO_INCREMENT) A unique identifier for each rule.
Table 63 scheduled_report_2 Table Column Type Comment rpt_id INTEGER PRIMARY KEY (AUTO_INCREMENT) A unique identifier for each scheduled report. rpt_dir VARCHAR(64) NOT NULL The top level report directory (under the 3par/ scheduledreports/ directory). rpt_name VARCHAR(64) NOT NULL The report name. A sub-directory of this name is created (under the rpt_dir directory) in which all scheduled reports are created. rpt_sched VARCHAR(200) NOT NULL The schedule for this report.
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 lists is either a “*” or a comma-separated list of individual dates, weekdays and hours respectively. stats_hours INTEGER NOT NULL The number of hours for which the region statistics should be considered.
Table 67 ldrgmoves_1 Table (continued) Column Type Comment adprovid INTEGER PRIMARY KEY (AUTO_INCREMENT) A unique identifier for each adaptive optimization configuration. ldid INTEGER NOT NULL The logical disk ID of the source LD region. ld_name VARCHAR(32) NOT NULL The LD name of the source LD region. ldoffmb INTEGER NOT NULL Offset in MiBs of the source LD region. vvid INTEGER NOT NULL The VV ID for the source LD region. vvspace VARCHAR(8) NOT NULL The VV space of the source LD region.
Table 68 recentsample_1 Table Column Type Comment resolution VARCHAR(32) NOT NULL The sample resolution, one of hires, hourly or daily. tsecs INTEGER NOT NULL Sample time in secs of the most recent complete sample of the resolution. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. The Sample Data and Inventory Tables The sample data tables include the space and performance samples of various objects in the systems.
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. NRM_AVAIL_DRTY INTEGER NOT NULL Number of normal unused chunklets that have not yet been initialized. These will be free for use in new LDs after the system has had time to initialize them.
The ldspace Table The ldspace__3 table holds logical disk (LD) space data samples. Table 71 ldspace__3 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. dom_name VARCHAR(32) NOT NULL The domain name that the LD belongs to.
Table 72 ldspaceinv__2 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. dom_name VARCHAR(32) NOT NULL The domain name that the LD belongs to. If the LD is not assigned to a domain, this column contains the value “-”.
Table 73 vvspace__3 Table (continued) Column Type Comment provv_type VARCHAR(32) NOT NULL The provisioning type of 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 that this VV is a copy of. vv_state VARCHAR(32) NOT NULL The state of the VV.
Table 73 vvspace__3 Table (continued) Column Type Comment usr_rawrsvd_mb DOUBLE PRECISION NOT NULL Raw (physical space including RAID overhead) user space reserved for the VV in MB. usr_used_mb DOUBLE PRECISION NOT NULL User space used by the VV in MB. usr_zn DOUBLE PRECISION NOT NULL User zones in the VV. usr_free_zn DOUBLE PRECISION NOT NULL Free user zones in the VV. The vvspaceinv Table The vvspaceinv__3 table holds the inventory for the vvspace__3 table.
Table 75 cpgspace__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. dom_name VARCHAR(32) NOT NULL The domain name that the CPG belongs to. If the CPG is not assigned to a domain, this column contains the value “-”.
The cpgspaceinv Table The cpgspaceinv__1 table holds the inventory for the cpgspace_1 table. Table 76 cpgspaceinv__1 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. dom_name VARCHAR(32) NOT NULL The domain name that the CPG belongs to.
Table 77 Common Performance Columns (continued) Column Type Comment rbytes DOUBLE PRECISION NOT NULL Total number of bytes read since the object was first created or restarted d_rbytes DOUBLE PRECISION NOT NULL Difference between rbytes value from last sample for the same object. rerror DOUBLE PRECISION NOT NULL Total number of read errors since the object was first created or restarted d_rerror DOUBLE PRECISION NOT NULL Difference between error value from last sample for the same object.
Table 77 Common Performance Columns (continued) Column Type Comment whist0 DOUBLE PRECISION NOT NULL Number of writes in service time bucket number 0. d_whist0 DOUBLE PRECISION NOT NULL Difference between whist0 value from last sample for the same object. ... ... ... whist31 DOUBLE PRECISION NOT NULL Number of writes in service time bucket number 31. d_whist31 DOUBLE PRECISION NOT NULL Difference between whist31 value from last sample for same object.
Table 78 Common Performance Metrics for a Sample Row (continued) Metric SQL Expression Write KBytes/sec CASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0 END Total KBytes/sec CASE WHEN d_now > 0 THEN (d_rbytes + d_wbytes)* 1000.0/d_now ELSE 0 END Read service time (millisec) CASE WHEN d_rcount > 0 THEN d_rticks / (d_rcount * 1000.0) ELSE 0 END Write service time (millisec) CASE WHEN d_wcount > 0 THEN d_wticks / (d_wcount * 1000.
Table 79 statpd__4 Table (continued) Column Type Comment port_s INTEGER NOT NULL The PCI slot in the node that the disk’s primary port is connected to (the “s” part of 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). disktype VARCHAR(32) NOT NULL The disk type. Currently, the disk types are • FC - Fibre channel drive. • NL - Nearline drive.
Table 81 statld__5 Table (continued) Column Type node INTEGER NOT NULL The node that owns the LD cpg_name VARCHAR(32) NOT NULL (common performance columns) Comment The name of the CPG that the LD belongs to. If the LD is not in a CPG, this column contains the value “----”. The rest of the columns are the common performance columns described in “Common Performance Table Columns” (page 205)). The statldinv Table The statldinv__4 table holds the inventory for the statld__5 table .
Table 83 statport__4 Table (continued) Column Type Comment • iscsi - iSCSI host ports. • free - ports that are not connected. (common performance columns) The rest of the columns are the common performance columns described in “Common Performance Table Columns” (page 205)). The statportinv Table The statportinv__4 table holds the inventory for the statport__4 table. Table 84 statportinv__4 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs.
Table 85 statvlun__3 Table (continued) Column Type Comment host_wwn VARCHAR(128) NOT NULL The host WWN (world wide name) or iscsi name. port_n INTEGER NOT NULL The node that the port is connected to (the “n” part of n:s:p). port_s INTEGER NOT NULL The PCI slot in the node that the port is connected to (the “s” part 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).
Table 87 statvvcmp__2 Table (continued) Column Type Comment vv_name VARCHAR(32) NOT NULL The VV name. rdhit DOUBLE PRECISION NOT The number of read cache hits for the VV. NULL d_rdhit DOUBLE PRECISION NOT Difference between rdhit value from last sample for same VV. NULL rdmiss DOUBLE PRECISION NOT The number of read cache misses for the VV. NULL d_rdmiss DOUBLE PRECISION NOT Difference between rdmiss value from last sample for same VV.
Table 89 statcpu__1 Table (continued) Column Type Comment d_usert DOUBLE PRECISION NOT Difference between usert value from last sample for same CPU. NULL syst DOUBLE PRECISION NOT Jiffies (0.01 sec) in system mode. NULL d_syst DOUBLE PRECISION NOT Difference between syst value from last sample for same CPU. NULL idlet DOUBLE PRECISION NOT Jiffies (0.01 sec) in idle mode. NULL d_idlet DOUBLE PRECISION NOT Difference between idlet value from last sample for same CPU.
Table 91 statlink__2 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. node INTEGER NOT NULL The node number node_to INTEGER NOT NULL The node number of the destination of the link. queue VARCHAR (32) NOT NULL The name of the Queue.
Table 93 statldrg_hourly_2 Table Column Type Comment tsecs INTEGER NOT NULL Sample time in secs. This is the Unix time and is the number of seconds since 0:00:00 Jan 1, 1970 GMT. sys_uid INTEGER NOT NULL A unique identifier for the system instance refers to the uniq_id for the system instance in the system_3 table. ldid INTEGER NOT NULL The logical disk ID of the LD region. ldoffmb INTEGER NOT NULL Offset in MiB of the LD region. vvid INTEGER NOT NULL The VV ID for the LD region.
10 Troubleshooting System Reporter Troubleshooting Overview The first step when troubleshooting System Reporter is to identify the component that is causing problems (see Figure 2 (page 26) for the structure of System Reporter). • If there are problems in sampling components see “Troubleshooting the Sampling Components” (page 217). Examples 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.
Installation Configuration On Windows, you can see the parameters with which the sampler was installed by typing the following command in that directory (which should contain the winserv.exe file) as follows: # winserv.exe showconfig "3PAR System Reporter sampler" Configuration of 3PAR System Reporter sampler: -displayname 3PAR System Reporter sampler (managed by WinServ) -noninteractive -binary C:\Program Files\3PAR\System Reporter\winserv.
Sampler Service/Daemon Errors Unlike HP 3PAR StoreServ Storage sampling errors, when the sampler service or daemon (sampleloop) incurs an error, it causes the service to exit. Before it exits, sampleloop sends an email with the error information if an email address is configured for reporting errors (see “Configuring Sampling Policies” (page 113)).
Figure 67 Microsoft Office Excel Internal Error If you experience a problem with a recovered copy of the workbook (Figure 68 (page 220)), try starting with a fresh copy of System Reporter workbook. Figure 68 Microsoft Excel Recovery Error Extracting Data from the Database with sysbck Sometimes it is necessary to extract some of the data from the System Reporter database. For example, you may want to send that data to HP to help in analyzing a performance problem.
For oracle: hosts string. Ignored if dbtype is sqlite. -db Name of the database. For SQLite this is the full file name, including the path, of the file that contains the database. -dbpwfile Name of file whose first line is the username and password for the database. Ignored if dbtype is sqlite.
From MS SQL to SQLite: sysbck -dbtype mssql -dbhost istat -db cliuser -dbpwfile dbpwfile -dbouttype sqlite -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime "07/14/2010" -inservname s074:s138 • From MS SQL to MySQL: sysbck -dbtype mssql -dbhost istat -db 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 • From MySQL
• 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 -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime "07/14/2010" -inservname s074:s138 The following examples show how to use sysbck without any optional parame
NOTE: When executing sysbck.exe from any other directory on Windows, ensure that the PATH environment variable is set to the System Reporter root directory path (by default, this path is C:\Program Files\3par). Dumping the Entire Database When you want to extract a large part of the database, it may be more efficient, both in time and disk space, to dump the entire database instead of using sysbck. The method for dumping the entire database depends on the database type.
11 Support and Other Resources Contacting HP For worldwide technical support information, see the HP support website: http://www.hp.
For information about: See: Configuring the Secure Service Custodian server in order to monitor and control HP 3PAR storage systems HP 3PAR Secure Service Custodian Configuration Utility Reference Using the CLI to configure and manage HP 3PAR Remote Copy HP 3PAR Remote Copy Software User’s Guide Updating HP 3PAR operating systems HP 3PAR Upgrade Pre-Planning Guide Identifying storage system components, troubleshooting information, and detailed alert information HP 3PAR F-Class, T-Class, and StoreSe
For information about: See: Planning for HP 3PAR storage system setup Hardware specifications, installation considerations, power requirements, networking options, and cabling information for HP 3PAR storage systems HP 3PAR 7200 and 7400 storage systems HP 3PAR StoreServ 7000 Storage Site Planning Manual HP 3PAR 10000 storage systems HP 3PAR StoreServ 10000 Storage Physical Planning Manual HP 3PAR StoreServ 10000 Storage Third-Party Rack Physical Planning Manual Installing and maintaining HP 3PAR 7200
Typographic conventions Table 97 Document conventions Convention Element Bold text • Keys that you press • Text you typed into a GUI element, such as a text box • GUI elements that you click or select, such as menu items, buttons, and so on Monospace text • File and directory names • System output • Code • Commands, their arguments, and argument values • Code variables • Command variables Bold monospace text • Commands you enter into a command line interface • Syste
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 (docsfeedback@hp.com). Include the document title and part number, version number, or the URL when submitting your feedback.
Index Symbols E 3PAR System Reporter User’s Guide, 53 3PAR System Reporter.xls, 48 3par-policy subdirectory, 125 3par-rpts subdirectory, 126 Excel client installing, 47 Excel Client link, 48 exporting table data, 17 A G adding a system to the list of systems to be sampled, 116 Administrator’s Guide, 23 Apache HTTP Server cgi-bin directory, 125 config.pl files, 125 Directory directives, 48 httpd.
Remove InServ, 46 Report Information control, 92 Report Type control, 75 reports displaying results as chart or table, 92 results, 70 types of, 75 requirements, 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 Stacked Area chart (example of), 95 Stacked Bars chart (