Set Database Maintenance Options for SQL Server - Intergraph Smart Instrumentation - Installation - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade Guide

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Instrumentation
PPMCategory
Installation
SPFVersion_custom
Version_SPI_custom
2018 (12.0)
Version_SPPID_custom
(none)
Version_SPEM_custom
(none)

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 be logged on with the System Administration logon name and password as defined in the Microsoft SQL Server Connection to use or run these options.

You should also update the database statistics as needed.