Monitoring in the CCMS
The Alert Monitor
CCMS Agents
Operating System Monitor
Workload Monitor
Global Workload Monitor
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)
Historical Database Performance Statistics (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 the Database with 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)
BUFFERS (Informix)
CKPTINTVL (Informix)
CLEANERS (Informix)
DD_HASHSIZE and DD_HASHMAX (Informix)
LOCKS (Informix)
LOGBUFF (Informix)
LRU_MAX_DIRTY, LRU_MIN_DIRTY (Informix)
LRUS (Informix)
MULTIPROCESSOR (Informix)
MULTIPROCESSOR, NUMCPUVPS, and SINGLE_CPU_VP (Informix)
NETTYPE (Informix)
NOAGE (Informix)
NUMAIOVPS (Informix)
NUMCPUVPS (Informix)
PHYSBUFF (Informix)
PHYSFILE (Informix)
RA_PAGES and RA_THRESHOLD (Informix)
SHMADD (Informix)
SHMTOTAL (Informix)
SHMVIRTSIZE (Informix)
SINGLE_CPU_VP (Informix)
STACKSIZE (Informix)
USEOSTIME (Informix)
SAP DB - Database Monitor
SAP DB - Database Monitor: Main Screen
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 Lock Waits (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)
Database Performance History Statistics (SAP DB)
SAP/SQL Server Database Monitor
Memory Usage
Space Usage
Server Engine
Detail Analysis Menu
The CCMS System Component Repository
Displaying Information from the Repository
Filling and Updating the Repository
Checking the Repository for Processing Errors
Creating a Central Repository
Role of a System Component Repository
Updating the Central Repository
Updating a Local Repository
Requesting an Update of a Repository
Creating the CSMREG User
The Control Panel
Starting the Control Panel
Displaying Developer Traces and Log Files in the Control Panel
Data Archiving Monitor
Messages and Alerts for Data Archiving Monitor
Technical Information for Data Archiving Monitor
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
Selecting Work Processes
Displaying 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
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