Monitoring in the CCMS
Configuring the Monitoring Architecture
Alert Monitor
Infrastructure of the SAP NetWeaver Management Agents
CCMS Agents
Operating System Monitor
Database Monitor
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 and Indexes
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)
Performance: Overview
Memory
Disk Space Usage
Dynamic Values in Current Activity Sub Screen
Detail Analysis Menu
SAP/IBM DB2 for Linux, UNIX, and Windows Database Monitor
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 Buffer (Nametab Buffer)
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
SAP Management Console
SAP Microsoft Management Console: Windows
Starting the SAP MMC
Layout of SAP Systems Manager Snap-In
Context Menu of the SAP Systems Manager Snap-In
Changing the Configuration of the SAP MMC
Configuring SAP MMC for Active Directory Services
Configuring SAP MMC for SAP System Landscape Directory
SAP MMC Enhancements for Active Directory Services
SAP MMC Integration with External Tools
Further Documentation and Troubleshooting