18 find offending processes and queries, 19 use the sql whiteboard, 20 use metric miner – HP Neoview Release 2.5 Software User Manual
Page 9
Get Information About Alerts.............................................................................................................183
Understand Row Detail Information for Alerts..................................................................................184
Use the Alerts Options Dialog Box.....................................................................................................186
Control the Refresh of Alerts..............................................................................................................187
Use the Update Alert Dialog Box........................................................................................................188
Update an Alert...................................................................................................................................189
Update Multiple Alerts.......................................................................................................................190
Make Notes About an Alert................................................................................................................190
About the Console Tab........................................................................................................................191
About System Offender......................................................................................................................193
Display the System Offender Tab.......................................................................................................193
See the Parts of the System Offender..................................................................................................194
Understand System Offender Privileges............................................................................................194
Find Offending Processes and Queries...............................................................................................194
Get Process Detail Information...........................................................................................................197
Get Pstate Information........................................................................................................................197
Get Children Process Information......................................................................................................198
Use the Children Processes Dialog Box..............................................................................................198
Understand Row Details for System Offender...................................................................................199
Get Query Workload Information.......................................................................................................201
Use the Workload Detail Dialog Box..................................................................................................201
Query Information.........................................................................................................................202
Understand the Warning Information...........................................................................................203
Compiler Statistics.........................................................................................................................203
Runtime Statistics..........................................................................................................................205
Cancel a Query From System Offender..............................................................................................207
Alter System Offender Parameters.....................................................................................................208
Use the Alter Offender Parameters Dialog Box..................................................................................208
Control the Refresh of System Offender.............................................................................................208
Use the System Offender History.......................................................................................................210
About the SQL Whiteboard................................................................................................................211
Display the SQL Whiteboard..............................................................................................................211
Learn About the SQL Whiteboard Panes............................................................................................211
Learn About the Statement List Pane.................................................................................................212
Learn About the Statement Pane........................................................................................................213
Understand Parameter Prompts....................................................................................................214
Understand Page Mode.................................................................................................................214
Cut, Copy, Paste, Undo, and Redo.................................................................................................215
Execute Highlighted Text..............................................................................................................215
Cancel a Query From the SQL Whiteboard...................................................................................215
Learn About the Statement Details Pane............................................................................................215
Reuse a Connection ............................................................................................................................216
Load and Save SQL Statements to a File.............................................................................................216
Highlight SQL Syntax.........................................................................................................................217
Manage the Layout of Panes...............................................................................................................217
Table of Contents
9