Monitoring Performance

Tools you can use to determine whether your system is making optimal use of available resources.

• Database Profiling Procedures
  Stored procedures that return database usage statistics.
• Event Profiling Procedures
  Event profiling procedures return performance statistics for stored procedures, functions, events, and triggers.
• Key Performance Indicators
  Set up a Statistics Collection in SAP Control Center to monitor key performance indicators (KPI) on the server. KPI values are grouped into collections and appear in SCC monitors.
• Buffer Cache Performance
  Buffer cache performance is a key factor in overall performance. The IQ UTILITIES Statement starts a cache monitor that collects buffer caches statistics. Use output from the cache monitor to fine-tune main and temp buffer cache memory allocation.