Caches

Monitor Adaptive Server data, procedure, statement caches, and in-memory storage.

• Monitoring Adaptive Server Data Caches
  Display information about data caches.
• Modifying Data Cache Sizes
  Sybase Control Center allows you to modify the size of the data cache, and specify the number of partitions in the data cache.
• Adding Data Cache Buffer Pools
  Sybase Control Center allows you to change the configuration of your data cache buffer pools.
• Data Cache Statistics and Details
  Interpret the Data Cache window for Adaptive Server.
• Monitoring the Adaptive Server Procedure Cache
  Display information about the procedure cache.
• Procedure Cache Statistics and Details
  The Procedure Cache screen displays information about the contents of the Adaptive Server procedure cache which is a memory pool used for stored procedures and a variety of other objects.
• Monitoring the Adaptive Server Statement Cache
  Display information about the statement cache, including cached SQL queries.
• Statement Cache Statistics and Details
  The Statement Cache window displays information about SQL queries and query plans stored in the Adaptive Server statement cache.
• Monitoring Adaptive Server In-memory Storage
  Sybase Control Center provides detailed information about in-memory storage.
• In-memory Storage Statistics and Details
  Interpreting the data on the In-memory Storage window.

---

Created February 25, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com