Improving System Performance

This section presents information on how to improve the performance of your system. In general, techniques for improving performance are designed to reduce unnecessary processing, network traffic, and blocking.

The techniques minimize these factors:

  • The number of unneeded records stored in tables
  • The number of records retrieved in queries
  • The number of locks on records in queries
  • The duration of locks on records
  • The size and duration of transactions
  • The fragmentation of tables and indexes
  • Timeouts
Note: Many topics in this section apply only to on-premises environments. These are the sections that also apply to cloud environments:
  • Centralized Vendor Metadata Databases
  • Customizations
  • User actions
  • Replication
  • Locking and blocking, except for monitor blocking