Monitoring database health and statistics

In Design mode, the Overview tab provides a high-level view of the database server and its features. This tab contains the following components:

  • Database   Located in the top left corner, this pane displays general information about the database server.

    To update the SQL Anywhere database server software click Check For Updates. See Checking for software updates.

  • Features   Located in the left bottom corner, this pane provides a visual representation of the database and its products and features. Clicking a node in the diagram expands the accompanying section in the Health And Statistics pane on the right; clicking the node again collapses the section.

    Note

    You must initiate the retrieval of MobiLink and QAnywhere information; otherwise, these nodes appear as unknowns (greyed-out). See MobiLink, QAnywhere, And Notifiers.

  • Health And Statistics   Located on the right, this pane displays statistics and information relating to the overall status of the database. The following collapsible panes are available:

    • Statistics   Displays general statistics, such as the number of pages read and written to disk. It displays a warning if there are any unscheduled requests. Click the warning to learn more.

    • Dbspaces   Displays a table listing all dbspaces. It displays a warning if a dbspace has less than 10% of free disk space remaining, or if a dbspace file cannot be found. Click the warning to learn more.

    • Transaction Logs   Displays information for the transaction log and the transaction log mirror, if applicable. This pane appears only when the database has a transaction log. It displays a warning if a log file has less than 10% of free disk space remaining. Click the warning to learn more.

    • Connected Users   Displays connected user and transaction statistics. Shows a table of the top 5 transaction times, if there are any. It shows a table of all blocked connections, if there are any. Displays a warning if there are any blocked connections. Click the warning to learn more.

    • Database Mirroring   Displays information for the primary, arbiter, mirror, and copy servers and for a database mirroring or read-only scale-out system when you are connected to the primary server for the system. This pane appears only when mirroring or scale-out is being used. It displays a warning if the arbiter or mirror server is disconnected. Click the warning to learn more.

    • Remote Servers   Displays a table of the remote servers used by the database. This pane appears only when a remote server exists. It displays a warning if a remote server is disconnected or a remote server cannot establish a connection. Click the warning to learn more.

      Note

      For JDBC remote servers, a warning appears that a connection has been disconnected or lost only if the JDBC remote server attempts to access a proxy object. See Configuration notes for JDBC classes.

    • MobiLink, QAnywhere, And Notifiers   Displays statistics for MobiLink, QAnywhere, and Notifiers. This pane only appears when MobiLink tables and views exist in the database.

      Note

      You must click the Refresh button to refresh the information in this pane. Unlike the information in the other panes, the information in this pane is not refreshed when you choose View » Refresh (or click the Refresh toolbar icon). You must refresh this information separately because refreshing could affect the database's performance.

    • SQL Remote Users   Displays a table of all SQL Remote users, and their most recent send and receive times. This pane only appears when the database has SQL Remote users.