Hp Neoview Release 2.4 Software Manuel d'utilisateur

HP Neoview Performance Analysis ToolsHP Part Number: 586321-001Published: September 2009Edition: HP Neoview Release 2.4 Service Pack 1

Include the document title, part number, and any comment, error found, or suggestion forimprovement you have concerning this document.10

1 Install and Start the HP Neoview Performance AnalysisToolsWhat are the HP Neoview Performance Analysis Tools?The Neoview Performance Analysis Tools

• Neoview Query Viewer — Live operational view of queries running on the Neoviewplatform. Standalone product. Same as Live View in Neoview Performance

Install the Neoview Performance Analysis ToolsThe HP Neoview Performance Analysis Tools are installed with a Windows installer. You canfind the instal

NOTE: You must connect to the Neoview data warehousing platform through the client driverto use the full capabilities and features of the Neoview Perf

NOTE: You are not required to use the same user name for connecting to NCI and NPA,however, you should log on to the same Neoview platform.Exit Any Ne

16

2 Use the WorkspaceNeoview Performance Analyzer WorkspaceThe workspace is the heart of the Neoview Performance Analyzer and all activity occurs within

The Neoview PaneThe Neoview pane allows you to define which system metrics and workload metrics you wantto display in the workspace content area. Thro

Define the Layout for the WorkspaceTo define the layout of your workspace, drag in the tools you want to use from the WorkspaceToolbox. The Timeline C

© Copyright 2009 Hewlett-Packard Development Company, L.P.

Help. For Neoview Query Viewer and Neoview Query Workbench, the commands areWorkspace, Edit, Tools, Display, and Help.Task ToolbarThe task toolbar pro

then be used as defaults for all subsequently created workspaces. To set up default values forindividual workspaces, set the options values on an acti

However, you can run the Neoview Query Viewer and Neoview Query Workbench tools asthose tools do not require access to the Neoview Repository.The Conn

3 Use the Workspace ToolboxThe Workspace Toolbox At a GlanceThe workspace toolbox is a panel of tools that you can use to graphically map the state of

System MetricsThe System Metrics tool is a shortcut to select the default system metric tools in a single view.Clicking on this icon will add these to

1. In the Triage Space, create a workload filter for the information you want to capture in theWorkload Metric. The items you define in the filter det

26

4 Use the Neoview PaneNeoview and Customized ViewsThe Neoview and customized views allow you to define which system and workload metricsyou want to di

that is graphed varies depending to the type of tool that you drag and drop onto the workspacecontent area (that is, in the Neoview pane or customized

NOTE: You cannot delete the Neoview pane.Other Tasks on GraphsPlace the cursor in a graph and right-click. The right-click menu provides these tasks:D

Table of ContentsLearn About This Document...7Publishing H

30

5 Use the Live View PaneThe Live View pane gives you a point-in-time display. It displays queries that are currentlyrunning on the system (or complete

NOTE: Neoview Query Viewer does not show the Get Session or Load Triage buttons.Configure Live View OptionsTo configure the Live View options, use the

Actions on Live View QueriesThe Live View displays its own SQL statements in the query list. Queries, SPJ calls, and otherSQL statements initiated by

Threshold Rule Creation WizardTo open the Threshold Rule Creation Wizard, which provides various menu items to help withthe creation or modification o

Workspaces TabThe Workspaces tab is the first tab displayed when the Threshold Rule Creation Wizard isopened. The Workspaces tab lists the workspaces

Space Fetched Queries will appear under the Conditions tab. These column headings can beused as conditions in a rule.When you select properties in the

Monitoring QueriesThe right pane of the Live View provides a pop-in screen that allows each individual query'sdetails to be viewed in a more user

The Query Details window provides a detailed view of the query and shows the query text andthe metrics related to the query split into these categorie

The title corresponds to the unique query ID for the query, as well as the username and connectioninformation, including the data source used to conne

Add Tools...23Ag

DescriptionMetricThe amount of time used by Neoview SQL to execute the query.Query Elapsed TimeTotal amount of processor (CPU) time utilized by the qu

to which you are connected, the information displayed will vary. This document provides a shortdescription for the metrics:DescriptionMetricIndicates

DescriptionMetricTop level error code returned by the query. This is also an indicatorthat shows whether the query completed with warnings, errors ors

DescriptionMetricTotal heap used by the Executor in the disk process.EID Heap UsedTotal memory allocated for the query.Total Memory AllocatedMiscellan

DescriptionMetricNumber of rows returned after applying the predicates. In a pushdown plan, all the used rows may not be returned.UsedRowsCount of the

On the upper right corner of the summary box is a magnifying glass icon, which allows you todrill down and display details about historical informatio

Statement and Service Counter DetailsTo bring up a detailed window that provides current service configuration on the Neoviewplatform and historical d

The Service Details grid lists all the services configured in the current system. The ServiceDetails also provides a view of the current state of all

Neoview WMS ConfigurationTo make it easy to navigate to the WMS configuration user interface, a menu item and acorresponding toolbar called Configure

• Click Apply to alter the system configuration.• Refresh refreshes the screen by re-fetching the system configuration.• Hold is enabled only if the s

Platform Status Counters Information...45Statement and Service Cou

service details and you can alter the service details. You can also double-click on a data gridrow to navigate to the specific service.• The Delete bu

This table describes the interface attributes:DescriptionAttributeName of the service. Service names support Neoview character sets.Service Name (max

DescriptionAttributeIndicates if the WMS server processes should temporarily store theSQL Text.SQL Text (True/False)Optional, free-form text you can e

DescriptionAttibutePercentage of CPU utilized. Default from WMS systemconfiguration.Max Processor Utilization (0-100) %Percentage of memory used. Defa

Stop a WMS ServiceTo stop a WMS service, on the Service Summary screen, select one or more services in the datagrid and click on the Stop button or th

Note this information about the Rules Summary:• When you select the Connection Rules tree node, only the connection rules are displayedin the right su

• The Export configuration icon (save disk) exports the entire WMS configuration into a scriptas WMS commands which can then be executed using a comma

When adding a rule, you can provide information in the following fields:DescriptionField NameName of the rule. Up to 24 characters (can be multi-bytes

Add a New Compilation RuleTo add a compilation rule, on the Add Rule dialog, set the Rule Type radio button to Compilation.• Warn Level and Rule Actio

When adding a rule, you can provide information in the following fields:DescriptionField NameName of the rule. Up to 24 characters (can be multi-bytes

Query Workbench Query Details...78Explain Plan..

case checking on the value. The Add Expr button adds the expression to the expressionslist.• You can choose AND/OR logical operators for the expressio

DescriptionField NameNumeric ValueExpression: PercentageEST_USED_ROWS, EST_ACCESSED_ROWS, EST_TOTAL_MEMORY,EST_CPU_TIME, Numeric valuesExpression: Val

• The Command Preview displays the WMS command that will be executed to apply ruleassociations to the system.• Click on the Refresh button to reload t

• Select the Admin Role to delete in the data grid and click on the Delete button or the deleteicon on the toolbar.• Select the Admin Role to delete i

• For each of the user-added admin roles, an ADD ADMIN command is generated. Thesystem-created admin roles (SUPER.SUPER, SUPER.SERVICES, ROLE.DBA) are

6 Use the Triage Space PaneThe Triage Space isolates queries you select in the Neoview view and customized views foranalysis in the Query Workbench. T

DescriptionTriage Space Pane PartA timeline controller that shows the elapsed time for the graphs (thepast 24–hour time period). The controller the sa

Query Candlestick GraphThe query candlestick graph is a graphical representation of the way workloads and queries ranover a specific period of time. T

Triage Space Button PanelThe Triage Space button panel commands:DescriptionCommandsShows a preview (three lines) of the SQL statement for each query.P

Dimensions:DescriptionFilterSelect application IDs from the list. Click on the icon at the rightside of the blank field for a list of IDs.Applications

Learn About This DocumentThis guide describes how to use the Neoview Performance Analysis Tools to monitor and analyzequeries.Publishing HistoryThis g

Triage Space Data GridThe Triage Space data grid is a tabular representation of the queries shown in the candlestickgraph. The list of queries control

The Query Details provides this information:• Type: MetricsDescriptionFieldEstimated cost of the query.Estimated CostQuery's starting priority. T

DescriptionFieldNumber of rows retrieved.Rows RetrievedTotal number of rows inserted, updated, or deleted in all tablesaccessed by the query.Num Rows

DescriptionFieldTime it took for the Neoview platform to execute the query.Total Execution TimeCurrent system time.Current System TimeTriage Space Sta

74

7 Use the Query WorkbenchQuery Workbench Pane in NPA = Neoview Query WorkbenchUse the Query Workbench pane to analyze queries. Query Workbench is most

DescriptionOptionEnables or disables colored process boundaries for explain plans inthe Query Workbench Query Details. When not checked, removescolor

buttons below the Query List as described in Query List. Checked queries are stored internallyfor fast retrieval. You can saved checked queries.For ex

Rename the QueryYou can rename the selected query in the Name box above the query field.StatisticsThe Statistics frame contains query statistics and d

you to in-depth information about the operators in the Neoview Query Guide. For informationabout the EXPLAIN statement, see the Neoview SQL Reference

Added these glossary terms:• Data source• Menu bar• Neoview platform• SQL statementIntended AudienceThis guide is intended for users who perform datab

The default icon (question mark) is used for operators not represented by a group.Analyze the Explain Plan Through the GridYou can sort on the fields

can execute in the master executor or ESP processes, and groupbys can execute in the masterexecutor, ESP, or ESAM processes.Certain scan operators alw

Execute OutputThe Execute Output tab shows the executed query. When you select the Execute Output tab,you see the rows retrieved and column count info

8 Tips for Query Plan Performance ImprovementsDetermine the Base Table Access StrategyThrough the FILE_SCAN operator, the query plan provides the info

3. If the table accessed is a fact table and if the scan is used for data aggregation, considerwhether the use of a summary/aggregate table or materia

Significance of Primary Key ColumnsThe primary key columns serve as the store-by columns for the table. In each partition, rows arestored in the order

86

9 Keyboard ShortcutsGeneral Shortcuts• Accept/OK => Enter or <CR> or Return• Cancel/escape => Esc• Close NPA=> Alt + F4 or Ctrl + q• Cl

• Saves As => Ctrl + s• Select All => Ctrl + a• Rename => Ctrl + r• Load workbench => Ctrl + Alt + l• Show/Fetch session => Ctrl + Alt

Glossarycardinality Estimated number of rows that will be returned by the current operator, based on table statistics,predicate values, and join crite

Help topics that describe how to use the HP Neoview Reports Tool.Neoview Reports Online HelpInformation about using the Repository, including descript

parallelism The ability of the Neoview database to execute large queries in parallel, using multiple CPUssimultaneously.partitionedparallelismA featur

IndexAAdmin roleadd, 62delete, 62Aggregate functions, 23for tools, 23performance, 83Analyzequeries, in Query Workbench, 76workloads, 24CCache Hits too

Query Workbench pane, 11start, 13Triage Space pane, 11Neoview platformconnect through ODBC, 21Neoview Query ViewerLive View pane, 31start, 14Neoview Q

add compilation rule, 58add connection rule, 56add execution rule, 59add rule, 56alter existing, 61associate rules to services, 61character set suppor