Monitoring and Tuning Performance

Describes the tools you use to determine whether your system is making optimal use of available resources.

• Getting Information Using Stored Procedures
  Several stored procedures display database information.
• Profiling Database Procedures
  Procedure profiling tracks the execution times of procedures, triggers, and other system events. Use profiling in Sybase Cental to identify performance issues for the database or database object.
• Data Model Recommendations
  Good database performance begins with good database design. Take the time to incorporate Sybase IQ's unique design features into your schema during development for better response time and faster query results.
• Monitoring Performance Statistics
  Use Performance Monitor in Sybase Central to display statistics for simplex and multiplex servers. Statistics display in a dynamic chart in real time.
• Monitoring the Buffer Caches
  Buffer cache performance is a key factor in overall performance. Buffer cache monitor logs buffer cache, memory, and I/O statistics.
• Buffer Cache Structure
  Changing the CACHE_PARTITIONS value may improve load or query performance in a multi-CPU configuration.
• Avoid Buffer Manager Thrashing
  Thrashing occurs when the system must write a dirty page before it can read a requested page, which drastically slows down the system. For optimum performance, always allocate enough cache to allow the page writers to keep up with the free space demand.
• Buffer Cache Monitor Checklist
  Review this checklist to adjust cache behavior that falls outside the normal range.
• System Utilities to Monitor CPU Use
  OS-specific utilities are available to monitor CPU usage.