Database

Database

This branch contains database maintenance functions.

Referesh Database - use this button to refresh all databases from SQL server instance and display them on a list.

Diagnose - run diagnose to see results for selected databases.

Diagnose indexes shows poorly used indexes since server SQL restart and missing indexes by index advantage according to SQL server engine.

Diagnose IO shows drive level latency information since server restart and calculates average latency per read, per write and per tota input/output for each database file.

Also see:

• Company settings - for creating a new database based on an existing one
• Backup - for creating and restoring backup copies of databases and executables
• Statistics - for statistical information about the database
• Referential Integrity Check - for checking the referential integrity of the database
• Import/Export Data - for importing and exporting data to and from specific tables
• Document Links and Transfers with the items:
  • Document Links
  • Transfer Docs. Between Doc. Types
  • Insert Documents
  • Transfer Documents
• System Log
• Report Log
• Changelog Settings
• Locked Records