Home
|
Previous Page
|
Next Page
Monitoring Database Server Performance
In This Chapter
Evaluating Your Current Configuration
Creating a Performance History
Importance of a Performance History
Tools For Creating a Performance History
Operating-System Tools
IBM Informix Server Administrator
Command-Line Utilities
The Database Server System Tables
Monitoring Overall Performance
Monitoring Database Server Resources
Monitoring Memory Use
Monitoring Buffer and Cache Rates
Monitoring the LRU Queues and Page Cleaning
Monitoring Threads
Monitoring Network Connections
Monitoring Virtual Processor Activity
Monitoring Table and Fragment Use
Monitoring Dbspaces and Chunks
Monitoring Page Reads and Writes to Chunks and Dbspaces
Monitoring Reads and Writes to Dbspaces
Monitoring Tblspaces
Monitoring Temporary Space Usage
Using System Catalog and System-Monitoring Interface Tables
Examining Information in the sysfragments System Catalog Table
Examining Information in the sysptprof System-Monitoring Interface Table
Monitoring Sessions and Queries
The Iterator Model of Extended Parallel Server and the Structure of Xplans
onstat Commands to Use for Displaying Information
Monitoring Current Session Activity and Resource Use
Monitoring Current Query Activity and Resource Use
Monitoring Resource Use by All Concurrent Queries
Using Command-Line Utilities to Monitor Query Execution
Monitoring User Threads and Transactions
Monitoring Data Flow Between Coservers
Monitoring Cartesian Joins
Performance Problems Not Related to the Database Server
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]