Skip Navigation LinksALVAO 11.1Index of windows and commandsALVAO WebAppAdministrationDatabase maintenance Skip Navigation Links.


Database maintenance

Options:

  • Refresh data for reports - add columns representing new database views in the Query schema, which are for data analysis and reporting, to the custom fields of requests and new properties of objects. This update does not need to be done before each analysis or report, but only after adding new custom fields or properties.
  • Optimize Performance - Update statistics and defragment indexes in the database and remove temporary data. This operation is performed regularly automatically. Use this command only if the database performance has dropped and the Alvao system is slowed down.
    Caution:
    We do not recommend optimizing performance during system uptime, as it can take several minutes and applications may stop responding during that time.
    Note:
    To optimize performance, you need to have ALVAO Service installed.
  • Repair Database- Recalculate precomputed values in the database, such as auxiliary tables of language localizations, paths in the object tree (AM), object names generated from property values (AM), etc. This command is for emergency situations only and does not need to be run regularly.

 

Did not find what you were looking for? Ask our technical support team.