Viewing Database Statistics

Sybase Control Center obtains database statistics by executing the Adaptive Server optdiag utility.

Sybase Control Center obtains database statistics by executing the Adaptive Server optdiag utility.

Note: To execute this command, you must have an agent configured for your Adaptive Server.
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
    • Archive Databases
    • In-Memory Databases
    • In-Memory Temporary Databases
  3. Click the Name field of the database.
  4. Click on the arrow and select Database Statistics.
    You see table, page details such as data and empty page counts, space utilization, and other statistics for the selected database.
Related tasks
Changing Database Ownership
Modifying Database Storage Allocations
Modifying the Transaction Log Cache and the Log I/O Buffer Size
Changing Database Options
Related reference
Database Properties