Neoview Workload Management Services Guide (R2.5)

Add an Execution Rule..................................................................................................................101
Set the Execution Rule Attributes..................................................................................................106
Alter an Execution Rule.................................................................................................................108
Delete an Execution Rule...............................................................................................................110
Associate Execution Rules With a Service.....................................................................................111
Display the Rules Summary................................................................................................................112
Understand the Rule Definitions........................................................................................................113
Associate Rules With Services.............................................................................................................114
Display the Services Associated With a Rule......................................................................................118
Display the Rules Associated With a Service......................................................................................119
6 Monitoring and Managing Workloads..................................................................121
Live View in the NPA Tools................................................................................................................121
Pause the Live View Display.........................................................................................................122
Refresh the Live View Display......................................................................................................122
Change the Automatic Refresh Interval........................................................................................122
Customize the Query Columns.....................................................................................................123
Preview the SQL Text.....................................................................................................................124
Hide Completed Queries...............................................................................................................124
Hide Transaction Boundaries........................................................................................................124
Configure the Live View Settings..................................................................................................125
Related Topics................................................................................................................................126
Monitor Queries..................................................................................................................................126
Select and Copy Queries to the Clipboard....................................................................................126
Load Queries From the Live View to the Triage Space.................................................................127
Display the Query Details..............................................................................................................127
Use the Monitoring Query Window........................................................................................128
Understand the Query Details.......................................................................................................130
Time-Based Metrics..................................................................................................................130
Rate-Based Metrics...................................................................................................................131
Miscellaneous Facts..................................................................................................................131
Rule Warnings..........................................................................................................................133
Query Text................................................................................................................................133
Get the Query Text..............................................................................................................133
Load the Workbench...........................................................................................................134
Colorize the Query Text......................................................................................................134
Compile-Time Metrics..............................................................................................................135
Run-Time Metrics.....................................................................................................................136
Per-Table Statistics....................................................................................................................137
Display the Session Statistics.........................................................................................................137
Understand the Session Statistics..................................................................................................138
Understand the Statement Counters.............................................................................................139
Display the State of the Queries Over Time..................................................................................140
Understand the Statement Counters Details............................................................................141
Copy the Query Summary Data to a Spreadsheet...................................................................141
Enlarge the Query Summary Graph........................................................................................141
Copy the Query Summary Graph to the Clipboard................................................................142
Save the Query Summary Graph to a File................................................................................142
Print the Query Summary Graph.............................................................................................142
Manage Queries..................................................................................................................................142
Hold a Query.................................................................................................................................142
How to Hold a Query...............................................................................................................143
Release a Query.............................................................................................................................144
How to Release a Query...........................................................................................................144
Table of Contents 5