Database Status Information

The Server Status Tool provides status information that is organized into groups of categories, each of which contains sub-categories. The Database group contains the following sub-categories of status information:

  • Alarm Redirections—Provides status information about any alarm redirections that are in process.
  • Buffers—Provides status information about the internal buffers used in Geo SCADA Expert.
  • Data File Cache—Provides statistical information about the data files that are used by Data Tables, Crystal Reports definition files, the latest Crystal Reports data files, and some other driver-specific files.
  • Data Files—Provides information about the various data files that belong to database items in Geo SCADA Expert.
  • Diagnostics—Provides statistical information about system activity that you can use to investigate the amount of system traffic.
  • Driver Point Updates—Provides status information about the top point update counts in the database, to help assess point data processing activity levels.
  • File Statistics—Provides status information about the database configuration and data files.
  • Geospatial Index—Provides diagnostic information about the contents of the index.
  • Indices—Provides you with faster access to specific areas of the database.
  • Interest—Provides status information about each database interest reference that is currently made between the server and the client(s).
  • Latest System Calls—Provides status information about the most recent system calls that have been executed.
  • Lock Diagnostics Read—Provides summary information about database read lock usage.
  • Lock Diagnostics Write—Provides summary information about database write lock usage.
  • Logic—Provides status information about the Logic programs that have executed during the latest snapshot interval.
  • Longest Point Updates—Provides information about the points that have taken the longest time to process.
  • Queued System Calls—Provides status information about the system calls that are waiting to be executed.
  • Reference Field Indices—Provides a list of which fields are indexed, and information about the number of target and source fields and the names of each index.
  • Searches—Provides information about the current search requests for data in the database.
  • Transactions—Provides information about the current configuration transactions that are running in the background.
  • Users—Provides status information about the user accounts on the system.