CCMS Monitoring
Database Monitor
SAP/Oracle Database Monitor
SAP/Oracle Database Monitor: Introduction
SAP/Oracle Database Monitor: Main Screen
Sorts (Oracle)
Time Statistics (Oracle)
Table Scans/Table Fetch (Oracle)
Redo Log Buffer (Oracle)
Calls (Oracle)
Data Buffer (Oracle)
Shared Pool (Oracle)
Detailed Analysis (Oracle)
Detail Analysis Menu (Oracle)
File System Requests (Oracle)
Buffer Busy Waits (Oracle)
Wait Events (Oracle)
Dictionary Buffer (Oracle)
SAP Client (Oracle)
Oracle Sessions
SQL Request (Shared SQL Area)
Exclusive Lockwaits (Oracle)
Database Message Log (Oracle)
Display V$ Tables (Oracle)
Performance Database (Oracle)
State on Disk (Oracle)
Parameter Changes (Oracle)
Table Scans: Problem Analysis (Oracle)
Checking for Full Tablespaces (Oracle)
Storage Management Errors (Oracle)
Checking for Freespace Problems (Oracle)
Checking Storage Parameters (Oracle)
Problems with Maximum Number of Extents (Oracle)
Displaying the Oracle Table Statistics
SAP/Oracle Database Monitor: Status of the Data
Consistency Checks
Database - ABAP Dictionary Consistency
Database Tables without a Unique Index
Creating Objects in the Database
Displaying Object Definitions
Naming Conventions for Indexes
Extent Analysis (Oracle)
Tablespace Analysis (Oracle)
Tables/Index Analysis (Oracle)
Missing Indexes
SAP/Oracle Performance Monitoring Strategies
Monitoring the Data Buffer (Oracle)
Monitoring the Shared Pool (Oracle)
Monitoring the Redo Log Buffer (Oracle)
Monitoring Calls (Oracle)
Monitoring Table Access Methods (Oracle)
Monitoring Sorting (Oracle)
Diagnosing SAP/Oracle Performance Problems
A Transaction is Running Very Slowly (Oracle)
Monitoring the Shared SQL Area (Oracle)
Monitoring Table and Index Fragmentation (Oracle)
All Transactions are Running Slowly (Oracle)
Checkpoint Monitoring (Oracle)
Checking the Optimizer Mode (Oracle)
Monitoring Oracle Resources
No Applications Can Run (Frozen System)
Important init.ora Parameters (Oracle)
DB_BLOCK_BUFFERS (Oracle)
DB_BLOCK_SIZE (Oracle)
DB_WRITERS (Oracle)
LOG_ARCHIVE_START (Oracle)
LOG_BUFFER (Oracle)
LOG_CHECKPOINT_INTERVAL (Oracle)
ROW_CACHE_CURSORS (Oracle)
SHARED_POOL_SIZE (Oracle)
SORT_AREA_SIZE (Oracle)
TIMED_STATISTICS (Oracle)
Data for the Oracle Database Monitor
Database Collector in Background Processing
Data for the Main Screen of the Database Monitor
Data for the Screen: Database Performance: Tables
Data for the Database Alert Monitor
SAP/Informix Database Monitor
Looking at the Informix Database Overview
Shared Memory (Informix)
Data Buffers (Informix)
Cleaners (Informix)
Log Buffers (Informix)
Database Activity (Informix)
Checkpointing (Informix)
Asynchronous I/O (Informix)
Detailed Database Analysis for Informix
Checking Wait Situations (Informix)
Checking Chunk I/O Activity (Informix)
Checking Sessions (Informix)
Checking Table Activity (Informix)
Checking SQL Statements (Informix)
Checking Exclusive Lockwaits (Informix)
Checking the Database Message Log (Informix)
Checking State on Disk (Informix)
Checking Pseudotables (Informix)
Checking Parameter Changes (Informix)
Checking Onstat Commands
SAP/Informix Performance Monitoring
Monitoring Data Buffers (Informix)
Monitoring the I/O Subsystem (Informix)
Monitoring Checkpoints (Informix)
Monitoring LRUS (Informix)
Monitoring CPU VPs (Informix)
Monitoring the Informix Network Interface
Monitoring Virtual Memory Usage (Informix)
Monitoring Optimizer Statistics (Informix)
Monitoring SQL Statement (Informix)
Diagnosis of SAP/Informix Performance Problems
Identifying Problems with One Transaction Running Slow (Informix
Identifying Problems with All Transactions Running Slow (Informi
Identifying Problems with a Frozen System (Informix)
Analyzing Sessions and Tables (Informix)
Analyzing Lockwaits (Informix)
Analyzing Lockwaits with onstat (Informix)
Checking Key Tuning Parameters (Informix)
ALARMPROGRAM (Informix)
BUFFERS (Informix)
CKPTINTVL (Informix)
CLEANERS (Informix)
DD_HASHSIZE and DD_HASHMAX (Informix)
LBU_PRESERVE (Informix)
LOGBUFF (Informix)
LRU_MAX_DIRTY, LRU_MIN_DIRTY (Informix)
LRUS (Informix)
LTAPEDEV (Informix)
MULTIPROCESSOR (Informix)
MULTIPROCESSOR, NUMCPUVPS, and SINGLE_CPU_VP (Informix)
NETTYPE (Informix)
NOAGE (Informix)
NUMAIOVPS (Informix)
NUMCPUVPS (Informix)
PHYSBUFF (Informix)
PHYSDBS (Informix)
PHYSFILE (Informix)
SHMADD (Informix)
SHMTOTAL (Informix)
SHMVIRTSIZE (Informix)
SINGLE_CPU_VP (Informix)
USEOSTIME (Informix)
SAP/DB2/400 Database Monitor
Data for the Database Monitor (DB2/400)
Database Monitor: Entry Screen (DB2/400)
Detail Analysis Menu (DB2/400)
Database Lock Monitor (DB2/400)
Wait Situations (DB2/400)
File Activity (DB2/400)
Database Monitor History (DB2/400)
SQL Statements (DB2/400)
Table Scans (DB2/400)
Sorts (DB2/400)
Temporary Files (DB2/400)
Index Advised (DB2/400)
Index Usage (DB2/400)
Index Creates (DB2/400)
State on Disk (DB2/400)
Consistency Checks (DB2/400)
System Catalog Tables (DB2/400)
Performance Tables (DB2/400)
SQL Packages (DB2/400)
DB2/400 Database Monitor: Debugging and Tuning Tips
When Should You Opt for Table Scan Access? (DB2/40
When Should You Opt for Sort Access? (DB2/400)
Temporary Indexes versus Permanent Indexes (DB2/40
Configuring the Database Monitor (DB2/400)
Finding Database Storage Problems (DB2/400)
Finding Database Damage (DB2/400)
Performing Deleted Records Analysis (DB2/400)
Analyzing Wait Situations (DB2/400)
Checking the Status of the QXDAEDRSQL Job (DB2/400)
SAP/DB2 UDB Database Monitor
Using the DB2 UDB Database Monitor
DB2 UDB for UNIX & Windows: Database Snapshot Screen
Buffer Pool Overview (DB2 UDB)
Buffer Pool Information (DB2 UDB)
Buffer Pool Direct Access (DB2 UDB)
I/O Servers and I/O Cleaners (DB2 UDB)
Locks and Deadlocks (DB2 UDB)
Calls (DB2 UDB)
Sorts (DB2 UDB)
Cache (DB2 UDB)
Tables (DB2 UDB)
Tablespaces (DB2 UDB)
Tablespaces Buffer Pool (DB2 UDB)
Tablespaces Direct Access (DB2 UDB)
Applications (DB2 UDB)
Applications Snapshot Applications (DB2 UDB)
Applications - Buffer Pool (DB2 UDB)
Applications Locks & Deadlocks (DB2 UDB)
Applications Statements (DB2 UDB)
Applications Cache (DB2 UDB)
Applications Agents (DB2 UDB)
SQL Cache Snapshot (DB2 UDB)
Lockwaits (DB2 UDB)
DB2 UDB Diag Log (DB2 UDB)
Deadlocks (DB2 UDB)
CLP Structures (DB2 UDB)
Parameter Changes (DB2 UDB)
Performance History (DB2 UDB)
Performance History: Call Statistics (DB2 UDB)
Performance History: Lock Statistics (DB2 UDB)
Logging Parameters (DB2 UDB)
SAP/DB2 Universal Database Performance Monitoring Strategies
Checking the Size of the Database Buffers (DB2 UDB)
Checking the Buffer Pool Hit Ratio (DB2 UDB)
Monitoring Lock List Utilization (DB2 UDB)
Monitoring the Sort Heap (DB2 UDB)
Monitoring Cache Quality (DB2 UDB)
Buffer Pool (DB2 UDB)
Sort Heap (DB2 UDB)
Checking Consistency (DB2 UDB)
State on Disk (DB2 UDB)
Space Statistics: Database (DB2 UDB)
Space Statistics: Tablespaces (DB2 UDB)
Space Statistics: Tables and Indexes (DB2 UDB)
State on Disk: Tablespaces (DB2 UDB)
State on Disk: Tables and Indexes (DB2 UDB)
Run Statistics (DB2 UDB)
Finding Storage Management Problems (DB2 UDB)
SAP DB Monitoring and Analysis
Database Monitor (SAP DB)
Cache Activity (SAP DB)
Commands (SAP DB)
I/O Activity (SAP DB)
Locking Activity (SAP DB)
Logging Activity (SAP DB)
Scan and Sort Activity (SAP DB)
Detail Analysis Menu (SAP DB)
DB Processes (SAP DB)
I/O Statistics (SAP DB)
Cache Statistics (SAP DB)
Region Statistics (SAP DB)
DB Filling Statistics (SAP DB)
Runtime Environment (SAP DB)
Parameter Changes (SAP DB)
Logging Statistics (SAP DB)
Storage Overview (SAP DB)
Exclusive Lockwaits (SAP DB)
Tables/Indexes (SAP DB)
Control Log File (SAP DB)
Database Message Log (SAP DB)
Overview (SAP DB)
Diagnostic Monitor (SAP DB)
Bottleneck Analysis (SAP DB)
Bottleneck Analysis Messages
Low data cache hit rate
Low catalog cache hitrate
Low converter cache hit rate
Cache swaps
High read rate (physical)
High read activity (physical)
High write activity (physical)
High read rate (virtual)
High parse activity
Low hit rate for table scans
Low hit rate for optimizer strategy
Low hit rate on <deletes/updates>
'Physical Temp Page Writes' high
High collision rate on SQL locks
Long waiting time with SQL collisions
Queue on SQL collisions
Lock escalations (<number of> table locks)
Log queue overflows
'Log I/O-Queue' too small
High log activity
Long write transactions
High collision rate on <name> region
High TAS collision rate
Large number of time-consuming commands
Long command runtime in DB kernel
Large number of self suspends (dispatches)
Long vsuspend time (user tasks)
Large number of vsleeps (user tasks)
Performance Database (SAP DB)
Database Assistant (SAP DB)
Current System Status (SAP DB)
Processes (SAP DB)
Task Manager (SAP DB)
DB Threads (SAP DB)
I/O Operations (SAP DB)
Overview (SAP DB)
Backup (SAP DB)
Synchronization Objects (SAP DB)
SQL Locks (SAP DB)
Waits (SAP DB)
Total (SAP DB)
Space Areas (SAP DB)
System Settings (SAP DB)
Bottlenecks (SAP DB)
SQL Performance (SAP DB)
Command Analysis (SAP DB)
Resource Use (SAP DB)
Messages (SAP DB)
Current Messages (SAP DB)
Old Messages (SAP DB)
Errors (SAP DB)
DBA Logs (SAP DB)
Tables (SAP DB)
Kernel Trace (SAP DB)
Configuration (SAP DB)
Parameters (SAP DB)
Current (SAP DB)
Change History (SAP DB)
Devspaces (SAP DB)
System Checks (SAP DB)
Database Operations Monitor (SAP DB)
Database Alert Monitor (SAP DB)
Statistics (SAP DB)
Database Fill Level (SAP DB)
Database Activity (SAP DB)
Diagnosing Performance Problems (SAP DB)
A Transaction is Running Very Slowly (SAP DB)
Missing Indexes (SAP DB)
Checking Database Free Space (SAP DB)
Checking Free Log Space (SAP DB)
Consistency Checks (SAP DB)
SAP liveCache Monitoring and Administration
liveCache: Connection
liveCache: Administration
Starting the liveCache
Stopping the liveCache
Initializing the liveCache
System Messages
liveCache: Configuration
Extending the Data Area
liveCache: Console
I/O Operations in the liveCache
Process Analysis
Process Overview
Active Tasks
Runnable Tasks
Sleeping Tasks
Task Activities
Causes of Suspends
Space Management
Memory Use
PSE Statistics
PSE Data
Synchronization Objects
Runtime Environment
Time use
liveCache Monitor
OMS/liveCache Base Layer
Class Container
Caches
SQL Statistics
liveCache: Performance
System Messages
liveCache Attributes
Cache Hit Rates
Disk Access
Status
Detail Analysis
Data Cache
Log Caches
Devspace Statistics in the liveCache
liveCache Configuration
Active Parameters
Displaying the OMS Versions
Transactions
Database Procedures
SAP/SQL Server Database Monitor
Memory Usage
Space Usage
Server Engine/Elapsed
SQL Requests
Detail Analysis Menu
Operating System Monitor
Calling the Operating System Monitor
Checking CPU Statistics
Checking Memory Utilization
OS/400 Wait States
Activity Level (OS/400)
Ineligible Queue (OS/400)
Job Priority (OS/400)
Pool Data in the OS/400 Operating System
PTF Check in the OS/400 Operating System Monitor
Operating System Collector
Special Features of Operating Systems
SAPOSCOL on a UNIX Host
Controlling SAPOSCOL from the Operating System
Collector Home Directory Path & Profile Parameters
Displaying the Collector Status
Displaying Collector Data
Setting Up RFC Communication to RFCOSCOL
Installing SAPOSCOL/RFCOSCOL for a Dedicated DB Server
Interpreting the Data
Starting SAPOSCOL
Stopping SAPOSCOL
Troubleshooting: Operating System Collector
Controlling SAPOSCOL from the R/3 System
Reducing CPU Load
The Alert Monitor
The Monitoring Architecture: Concept
What is Predefined in the Alert Monitor?
Working with the Alert Monitor Tree
Tree Components
Working with Log Attributes
Tutorial
Detailed Tutorial
Alerts
The Alert Browser: Working with Alerts
Starting the Alert Monitor
Starting the Alert Browser and Displaying Alerts
Switching Views: System Status, Open Alerts
Switching Levels of Detail in Views
Switching Between Monitors
Stopping and Restarting Alert Generation
Monitoring Multiple R/3 Systems
Turning Automatic Refresh On and Off
Setting the Time Zone
Monitoring the Operating System Using the Alert Monitor (DB2/400
Monitoring Memory Management Using the Alert Monitor (DB2/400)
Monitoring the Database Using the Alert Monitor (DB2/400)
Alert Monitoring Tree: Illustration
Completing Alerts
Displaying Completed Alerts
Reorganizing Completed Alerts
Resetting MTEs and Alerts
Displaying Detailed Data and Adjusting the Display
Availability Monitoring
Setting Up Availability Monitoring
Customizing Availability Monitoring
Rule MTEs: Rule Descriptions and Use
Monitor Sets
Customizing the Alert Monitor
Creating Your Own Monitors
Changing an Existing Monitor
Changing Properties and Maintaining Methods
Method Assignments
Defining, Releasing and Transporting Methods
Starting Methods
Assigning Methods to MTE Classes and Monitoring Properties Varia
Defining Automatic Alert Notification
Monitoring Properties Variants
Creating and Changing Monitoring Properties Variants
Copying Monitoring Properties Variants
SAP-DEFAULT
Creating a New SAP-DEFAULT Variant
Performance Database
Displaying Performance Data
Graphing Performance Data
Creating and Scheduling a Reorganization Schema
Assigning a Reorganization Schema to an Attribute Group
Maintaining the Performance Database
Deleting Local Files
Self-Monitoring in the Alert Monitor
Increasing the Shared Memory Area
System Groups in the Alert Monitor
Maintaining Local System Groups
Maintaining Centralized System Groups
Transaction- and Client-Specific Monitoring
Monitoring Release 3.x Systems
SQL Server Alert Monitor
Alerts for SQL Server
Viewing and Customizing Threshold Values
The CCMS System Repository
Filling or Updating the Repository
Checking for Repository Processing Errors
Creating the CSMREG User
Updating the Central Repository
Updating the Local Repository
Displaying Information from the Repository
Creating a Central Repository
The Control Panel
Starting the Control Panel
Developer (Internal) Traces
Accessing Log Files
Workload Monitor
User Modes
Analysis Views and Profiles
Workload Statistics
Response Times: Rules of Thumb
Displaying Application Server Workload
Displaying Workload over Specific Time Periods
Displaying Users per Instance
Displaying Transaction Workload
Displaying Spool Statistics
Comparing Workload Between Servers
Saving User-Specific Views
Displaying Top 40 Response Times
Displaying Application Statistics
Business Transaction Analysis
Working with the Workload Collector
Working with the Performance Monitor Collector
Reorganizing the Table MONI
Configuring the Data Collector
Scheduling Data Collector Reports
RSHOSTPH
RSHOSTDB
RSORASNP
RSDBPREV
RSORATDB
RSORAPAR
RSORA811
RSSTATPH
RSSTAT60
RSSTAT80
RSSTAT88
RSSTAT87
RSSTAT83
Parameters for RSSTAT80/83 and RSSTAT87/88/89
Data Archiving Monitor
Messages and Alerts
Additional Technical Information
R/3 Accounting Interface
Database Resources
Operating System Resource
R/3 System Resources
Installing and Setting up the R/3 Accounting Interface
Creating an Account
Creating the Table of Contents
Reading Accounting Data
Example 1: Using the User Master Record
Example 2: Not Using the User Master Record
Global Work Process Overview: Contents
System-wide Work Process Overview
Selecting Work Processes
Detailed Work Process Information
SAP Buffers
Buffer Components
Buffer Synchronization
Buffer Types
Repository Buffers (Nametab Buffers)
Table Buffers
Displaying Table Buffers
Program Buffers
SAPgui Buffers
Roll and Paging Buffers, Extended Memory
SAP Calendar Buffer
Import / Export Buffers
SAP Cursor Cache
SAP Cursor Cache for Oracle, Informix, Adabas and DB2 for AIX
SAP Cursor Cache for MS SQL Server
The Buffer Monitor
Buffer Monitor and Tune Summary
Tuning SAP Buffers
Special Aspects of Tuning
Working with Call Statistics
Buffer Quality
Reasons for Poor Buffer Quality
High Buffer Quality
Typical Parameter Settings for SAP Buffers
Object Swapping
Checking Memory Usage
Changing Buffer Sizes
Adjusting Pool Sizes
How Much Operating System Paging is Acceptable?
Directory Space and Data Space
Microsoft Management Console: Windows NT
Starting the MMC
Layout of R/3 Manager Snap-In
Context Menu of the R/3 Manager Snap-In
Changing the Configuration of the MMC
Configuring MMC for Active Directory Services
MMC Enhancements for Active Directory Services