SAP Database Performance Analysis
Performance Analysis Tools
Skip to end of metadata
Created by Guest, last modified by Birgit Malik on Aug 08, 2018
Go to start of metadata
SAP® MaxDB - Performance Analysis Tools
This section describes the general tools and transactions for performance monitoring.
Moderators: Christiane Hienger
WIKI Space Editor: Thiago Lüttig.
Introduction
SAP System
Non SAP System
SAP MaxDB
SAP System Monitoring
SAP Workload Monitor (ST03, ST03N)
SAP Memory Configuration Monitor (ST02)
SAP Business Transaction Analysis (STAD)
SAP Runtime Analysis (SE30, ST12)
Operating System Monitoring
SAP Transaction OS06 and OS07
SAP Transaction ST06
SAP MaxDB Database Monitoring
SAP MaxDB Database Assistent (DBACockpit, LC10.....)
SAP MaxDB Database Analyzer
SAP MaxDB Command Monitor
SAP MaxDB Resource Monitor
SAP MaxDB System Table MONITOR
SAP MaxDB Database Console (XCONS)
SQL Trace (ST05)
Table Analysis (DB05)
ABAP Dictionary (SE11)
SAP Notes
Note 948066: Performance Analysis: Transactions to use
Note 530394: Using the Database Analyzer for bottleneck Analysis
Note 945757: Daily Job for administration of Monitoring Data
Note 748225: Measurement IO Times on liveCache/MaxDB Data/Log volumes
MaxDB Training Material
Session - Recording: CCMS Integration into the SAP System
Session - Slides: CCMS Integration into the SAP System
Session - Recording: Performance Optimization with SAP MaxDB
Session - Slides: Performance Optimization with SAP MaxDB
Details
SAP System
The SAP system offers a range of transactions with which you can analyze performance problems: ST03, ST05, STAD, SE30, DB05, DBACOCKPIT, DB50, DB59, and SE11.
back to top
Non SAP System
In a non-SAP system, the application has to make appropriate analysis programs available, or you have to use operating system tools. This guide does not cover these.
back to top
SAP MaxDB
SAP MaxDB provides various tools and methods for the analysis of database performance bottlenecks and monitoring current database activities. Some of these tools were originally developed only for testing and analysis in SAP MaxDB development, but can also be used by experienced database administrators for performance analysis. The following are of particular importance for this performance analysis:
The Database Analyzer program for analyzing performance bottlenecks.
The Command Monitor diagnosis function for identifying long-running or poorly-processed SQL statements.
The Resource Monitor diagnosis function for measuring all long-running SQL statements.
In SAP systems, you can control and analyze all functions and results using transaction DBACOCKPIT and DB50. The output here is formatted in a user-friendly way. You can also control the functions by means of SQL statements. However, the evaluation requires knowledge of the system tables used as well as the interpretation of the data contained therein. Database Studio provides a quick overview of the function(s) that is (are) currently active. You find entries for Command Monitor, Resource Monitor and Database Analyzer, together with the respective status.
Database Analyzer, Command Monitor, Resource Monitor, DBA Cockpit
back to top
maxdb
netweaver
stub
maxdb_performance_tools
15 Child Pages
Page: ABAP Dictionary (SE11)Page: Business Transaction Analysis (STAD)Page: Command MonitorPage: Helpful SAP Notes For MonitoringPage: Resource MonitorPage: Runtime Analysis (SE30 and ST12)Page: SAP MaxDB Database AnalyzerPage: SAP MaxDB Database Console (XCONS)Page: SAP MaxDB System MonitoringPage: SAP Memory Configuration monitor (ST02)Page: SQL Trace (ST05)Page: Transaction DB05Page: Transactions OS06 and OS07Page: Transaction ST06Page: Workload Monitor (ST03 or ST03N)
Cross Platform Performance
Cross Platform Performance
Database Performance Analysis
Skip to end of metadata
Created by Walle Zhao, last modified on Nov 02, 2018
Go to start of metadata
Offer help to customers and support engineers analyze Database performance, including all the database platform, Oracle, MSSQL, HANA, IBM, MAXDBetc.
Table of Contents
Table of Contents
DBA Cockpit
Related SAP Notes&Help Portal
ORACLE
Related SAP Notes/KBAs
Wiki Page
DB2 UDB for LINUX, UNIX and Windows
Related SAP Notes/KBAs
WIKI Page&Support Portal
MAXDB
Related SAP Notes
WIKI Page&Support Portal
SAP Sybase ASE
Related SAP Notes
WIKI Page&Support Portal
SAP HANA
Related SAP Notes/KBAs
WIKI Page&Support Portal
SQL Server
Related SAP Notes
WIKI Page&Support Portal
DBA Cockpit
The DBA Cockpit is a platform-independent tool that you can use to monitor and administer your database. It provides a graphical user interface (GUI) for all actions and covers all aspects of handling a database system landscape. You can run the DBA Cockpit locally on an SAP NetWeaver-based system by calling the DBACOCKPIT transaction.
Universal to all Databases
Analysis depends on the Database Version and Release
Database Configuration and layout can be checked
SQL Cache can be analysed for most expensive SQL
A HTTP Connection is necessary to access the Web-Dynpro DBACOCKPIT, for some customers this is the only option to access the dbacockpit
Related SAP Notes&Help Portal
2125429 - Performance Troubleshooting Guide - DBACockpit [VIDEO]
To know more,please check in DBA Cockpit Help Portal.
The entry screen of the DBA Cockpit is divided into following areas
ORACLE
Related SAP Notes/KBAs
1171650 - Automated Oracle DB parameter check
1431798 - Oracle 11.2.0: Database Parameter Settings
1888485 - Database Parameter for 12.1.0.2
618868 - FAQ: Oracle performance
Wiki Page
Oracle
Tuning Oracle
DB2 UDB for LINUX, UNIX and Windows
Related SAP Notes/KBAs
899322 - DB6: DB2 9.1 Standard Parameter Settings
1086130 - DB6: DB2 9.5 Standard Parameter Settings
1329179 - DB6: DB2 9.7 Standard Parameter Settings
1692571 - DB6: DB2 10.1 Standard Parameter Settings
1851832 - DB6: DB2 10.5 Standard Parameter Settings
2303771 - DB6: DB2 11.1 Standard Parameter Settings
WIKI Page&Support Portal
SAP on DB2 for Linux, UNIX, and Windows
DB2 Performance
Physical read/write Analysis
MAXDB
Related SAP Notes
725489 - SAP MaxDB performance analysis tools
819641 - FAQ: SAP MaxDB performance
819324 - FAQ: SAP MaxDB SQL optimization
2056680 - SAP MaxDB runtime analysis: Restore data backup
1357553 - MaxDB / liveCache Performance on HP-UX
WIKI Page&Support Portal
SAP MaxDB
Tuning SAP MaxDB
SAP Sybase ASE
Related SAP Notes
1766238 - FAQ: Query Optimization -in process
1764611 - FAQ: SAP Sybase ASE Update Statistics -in process
2162183 - Frequently asked questions on SAP ASE for Business Suite
2371160 - FAQ: BW archiving to SAP IQ performance considerations
1642301 - Collecting diagnostic data for Sybase ASE support
2087323 - SYB: Important solved problems for SAP Applications running on SAP ASE
WIKI Page&Support Portal
SAP ASE HOME
Performance and Tuning
SAP HANA
Related SAP Notes/KBAs
2000002 - FAQ: SAP HANA SQL Optimization
1999930 - FAQ: SAP HANA I/O Analysis
2000000 - FAQ: SAP HANA Performance Optimization
1732157 - Collecting diagnosis information for SAP HANA [VIDEO]
1999998 - FAQ: SAP HANA Lock Analysis
1813020 - How to generate a runtime dump on SAP HANA
1999997 - FAQ: SAP HANA Memory
1999993 - How-To: Interpreting SAP HANA Mini Check Results
2443066 - Standard transactions or standard reports have poor performance after Database migration to SAP HANA Databas
WIKI Page&Support Portal
SAP HANA and In-Memory Computing Wiki Page
SAP HANA Troubleshooting and Performance Analysis Guide → Statement Performance Analysis
SAP HANA Cockpit Help Portal → Administration and Monitoring Functions
Click here to expand the Performance Monitoring and Analysis
SQL Server
Related SAP Notes
521750 - FAQ: SQL Server 2000 I/O performance
987961 - FAQ: SQL Server I/O performance
1152848 - FAQ: SQL Server Wait Events
555223 - FAQ: Microsoft SQL Server in NetWeaver based systems
WIKI Page&Support Portal
SAP on SQL Server
SQL Performance
No labels
