Database Analysis

The database is a central resource in any SAP system and for that reason it deserves special attention when it comes to performance and stability, since all users may be affected, if the database is not performing well.

SAP systems may use an Oracle, SQL Server, DB2 UDB, SAP DB or Informix database. Depending on this factor, the monitors and the indicators to look at when analyzing the database are different. With the exception of the individual indicators and characteristics of every database, analyzing a database follows the same general rules. You may check for hardware bottlenecks in CPU and memory in the database server, check for Input/Output contention in the hard disks, ensure that parameter settings are configured ...

Get SAP R/3 Handbook, Third Edition, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.