Home
|
Previous Page
|
Next Page
Tuning Database Server Performance
In This Chapter
Tuning Memory Allocation
Managing Memory for DSS Applications
Limiting the Number of Concurrent Queries
Managing Memory for OLTP Applications
Adjusting the Size of Virtual and Resident Shared Memory
Tuning I/O for Tables and Indexes
Sequential Scans
Light Scans
Light Appends
Duplicate Copies of Small Tables
Keeping Small Tables in Memory
Unavailable Data
Managing Resource Use for Specific Sessions
Setting the Mutability Property of a Session Environment Variable
Using the sysdbopen() Procedure
Setting Values for All Mutable Environment Variables
Monitoring the Mutability Property of a Session
Changing the Mutability of an Active Session
Overriding PDQPRIORITY Settings
Using the SET ENVIRONMENT Options
Enabling Optimizer-Determined Memory Allocation
Limiting the Number of Scan Threads
Limiting CPU Virtual-Processor Use for Queries
Limiting Temporary Space for Query-Operator Overflow
How the SET ENVIRONMENT Options Interact
Specifying the Initial Environment for Sessions
Adjusting Resource Use by Specific Sessions
Resetting PDQPRIORITY
Resetting the Schedule Level
Stopping Queries
Monitoring Lock Waits and Lock Errors
Monitoring Deadlocks
Reducing Deadlocks
Setting Global Priorities for Queries
Setting Schedule Levels
Using the Admission Policy
STRICT Policy
FAIR Policy
Understanding the Effect of PDQPRIORITY on Query Admission
Changing Global Resource Limits Temporarily
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]