Monitoring in the CCMS
Configuring the Monitoring Architecture
The Alert Monitor
CCMS Monitoring Console
CCMS Agents
Operating System Monitor
Database Monitor
SAP/Oracle Database Monitor (New)
Main Monitor
Viewing History Information
Overall Activity
Buffer Busy Waits
Filesystem Requests
System / Wait Events
Undo Statistics
Automatic Segment Space Management
Online Redefinition Tables
Resumable Space Allocation
Parallel Query
Performance Database
Resource Consumption
Oracle Session Monitor
SQL Request
Top SQL Statements
Table Access Monitor
Latch Monitor
PGA Monitor
SGA Monitor
Exceptional Conditions
Enqueue Monitor
Lock Monitor
Database Message Log
Additional Functions
Display V$/GV$ Views
Parameter Configuration
Arbitrary Monitoring
System Statistics for the CBO
Checkpoints
Data Guard
SAP/Oracle Database Monitor (Old)
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/SQL Server Database Monitor
Memory
Disk Space Usage
Dynamic Values in Current Activity Sub Screen
Detail Analysis Menu
CCMS: SAP/DB2 UDB for UNIX and Windows
Table Analysis
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
SAP Accounting Interface
Database Resources
Operating System Resource
SAP System Resources
Installing and Configuring the SAP 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, MaxDB 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 SAP Systems Manager Snap-In
Context Menu of the SAP Systems Manager Snap-In
Changing the Configuration of the MMC
Configuring MMC for Active Directory Services
MMC Enhancements for Active Directory Services
Further Documentation and Troubleshooting