Set Database Maintenance Options for SQL Server - Intergraph Smart Engineering Manager - Installation & Upgrade - Intergraph

Intergraph SmartPlant Engineering Manager Installation and Upgrade

Language
English
Product
Intergraph Smart Engineering Manager
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
Smart Electrical Version
2015 R1 (7.1)
Smart Instrumentation Version
(none)
Smart P&ID Version
7.1 (2014 R1)
Smart Engineering Manager Version
7.2 (2014 R2)

You set the database maintenance options for SQL Server using the DBCC Utility. It is recommended that you run the following options about once a week:

  • CHECKCATALOG

  • CHECKDB

You must use an SA connection for running these options.

You should also update the database statistics as needed.