Run database administration processes - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
10.1(2014R1)

When you perform administrative tasks on a database, you should not run certain processes concurrently. In other cases, running certain processes concurrently might also affect performance. The table below shows a matrix of these different processes:

Process 2

Make Model Changes

Bulkload

Backup

Report or Drawing Extraction

Process 1

Bulkload

Sync model with Catalog

Project Management Backup

SQL Backup

Bulkload

Bulkload

Risk

-

No

No

No

Risk

Synchronize model with Catalog

Risk

No

-

No

No

Yes

Regenerate Report DB

Risk

No

No

Slow

Slow

No

DB Maintenance

Database Integrity

Slow

Yes

Slow

Yes

Yes

Slow

Clean DB Command

Risk

Yes

Yes

Yes

Yes

Yes

DB Maintenance

No

No

No

No

No

No

Check Fragmentation

Yes

Yes

Yes

No

No

Yes

Backup

Project Management Backup

Yes

No

No

-

Slow

Yes

SQL Backup

Yes

No

No

Slow

-

Yes

Report & Drawing

Report Extraction

Yes

Yes

Yes

Yes

Yes

Yes

Drawing Extraction

Yes

Risk

Yes

Yes

Yes

Yes

SPR

SPR Data Creation

Slow

Slow

No

Yes

Yes

Yes

IFC

IFC

Yes

Yes

Yes

Yes

Yes

Yes

Legend

  • Yes - Processes can be run concurrently with no risks or performance impact.

  • No - Processes cannot be run concurrently.

  • Risk - Processes can be run concurrently, but there are risks involved.

  • Slow - Processes can be run concurrently. However, you will see slower performance while the processes are running.