SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
xii
14. Measuring Performance
Maintaining Local Autonomy in a Network for SQL/MX Release 3.0 13-12
Creating a Distributed SQL/MX Database 13-19
Creating, Registering, and Unregistering Catalog References 13-20
Distributing SQL/MX Database Objects 13-20
Altering Distributed Objects 13-22
Dropping Distributed Objects 13-23
Enhancing the Performance of a Distributed Database 13-23
Using Co-located Indexes in a Distributed Database 13-23
Using Remote Application Processes 13-23
Changing Network Environments
13-24
Managing Mixed Versions of NonStop SQL/MX
13-25
14. Measuring Performance
SQL/MX Tools for Gathering Statistics 14-1
SHOWLABEL Command 14-2
SET STATISTICS and DISPLAY STATISTICS Commands 14-3
Measure Performance Measurement Tool 14-5
Statistics and Reports for NonStop SQL/MX 14-7
SQL/MX Measurement Models 14-9
15. Enhancing SQL/MX Database Performance
Using Queries in an SQL/MX Database 15-2
Understanding the Implications of Concurrency 15-2
Minimizing Contention 15-4
Avoiding Contention Between DDL or Utility Operations
15-6
Other Operational Considerations
15-6
Keeping Statistics Current
15-7
Managing SQL/MX Buffer Space 15-8
How DP2 Manages and Reuses Query Plan Fragments
15-9
Causes and Symptoms of Query Plan Fragment Reuse Failures
15-9
Reduction of Plan Fragment Size for Unique Queries
15-10
Using SCF STATS DISK to Monitor SQL/MX Statistics and Reuse Failures 15-10
Using SCF ALTER DISK to Resize the SQLMXBUFFER Attribute 15-12
Strategies for Reducing Reuse Failures 15-13
Managing DP2 Data Cache Memory Size 15-14
Maximizing Disk Process Prefetch Capabilities 15-15
Optimizing SQL/MX Memory Management
15-15
Optimizing Index Use
15-16
Maximizing Parallel Index Maintenance 15-17
Using Co-located Indexes 15-17