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.