Viewing Database Statistics

View database statistic using SAP Control Center.

Note: To execute this command, you must have an agent configured for your SAP ASE 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, then click the drop-down 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