Monitor Simplex Servers

Statistics allow you to monitor the availability and performance of a simplex server.

• Viewing Overview Statistics
  Display high-level statistics for the selected SAP Sybase IQ server.
• Viewing All Statistics
  Display all the statistics for the selected SAP Sybase IQ server.
• Viewing Engine Statistics
  Display the engine statistics for the selected SAP Sybase IQ server.
• Viewing Connection Statistics
  Display the connection statistics for the selected SAP Sybase IQ server.
• Viewing Transaction Statistics
  Display transaction statistics for the selected SAP Sybase IQ server.
• Viewing Dbspaces Statistics
  View dbspace size and usage details for a single server, or for a node in a multiplex, including shared temporary dbspaces.
• Viewing Store I/O Statistics
  Display the store I/O statistics for the selected SAP Sybase IQ server.
• Viewing Cache Statistics
  Display the cache statistics for the selected SAP Sybase IQ server.
• Viewing Table Version Statistics
  Display the table version statistics for the selected SAP Sybase IQ server.
• Viewing Operations and Requests Statistics
  Display the operation and request statistics for the selected SAP Sybase IQ server.
• Viewing Network Statistics
  Display the network statistics for the selected SAP Sybase IQ server.
• Viewing Table Page Usage Details
  Display page usage details of tables or materialized views for the selected SAP Sybase IQ server. Table Page Usage only applies to system tables in the system store (IQ catalog store).
• Viewing Table Lock Details
  Use the Sybase Control Center node-level monitor view to display details of locked tables, views or materialized views for the selected SAP Sybase IQ server.
• Viewing Deadlock Details
  Write locks maintain the reliability of information by preventing concurrent access to rows or tables by more than one transaction. Transaction blocking and snapshot versioning manage statements until a lock becomes available. However, deadlock can occur when a set of transactions arrive at a state where none of them can proceed. Sybase Control Center allows you to view deadlock details, and to specify how these details are displayed.
• Viewing Monitor Settings Details
  You can control the rate at which data on monitor screens and charts is refreshed, the amount of time covered by charts.