Appendix: SQL Database Maintenance - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (SQL Server)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13.1

SQL Server contains additional maintenance procedures that can improve database performance. These procedures are performed directly in SQL Server—not in the Smart 3D software—and are performed by a SQL administrator. Detailed procedures are not described in this section.

Backing Up Transaction Logs

Transaction logs are backed up to release space on the transaction log file and to prevent indefinite growth.

In a Global Workshare environment, transaction log backups are only needed for the set of host databases. These databases experience the largest log file growth due to the Recovery Model property being set to Full. See Recovery Models (SQL Server) in SQL Server Help.

Transaction log backups are not used for restoring databases. You should schedule Smart 3D backups for disaster recovery. See Backup Command.

You can create a single maintenance plan for multiple databases (such as the site, site schema, catalog, catalog schema, and model that comprise a standard Smart 3D database set), or create a separate maintenance plan for each database. See Maintenance Plan Wizard in SQL Server Help.

Updating Statistics to Optimize Queries

The SQL Server Query Optimizer uses database statistics to efficiently retrieve and update data. The Query Optimizer automatically updates statistics. You can also manually update statistics more frequently to improve query performance, especially when creating and updating drawings. You can use UPDATE STATISTICS or the Transact-SQL stored procedure sp_updatestats. See Statistics Used by the Query Optimizer and UPDATE STATISTICS (Transact-SQL) in SQL Server Help.