Optimizing the production databases

When implementing the ArcGIS for Maritime: Charting in an organization, there are several ways to maintain your system so that performance is not degraded over time.

In an effort to maximize performance, production databases are compressed when checked into the product library; while that addresses routine maintenance, large updates that occur during the product lifecycle may require additional attention.

The steps below should be performed after you baseline the product to help overall performance. These steps should also be done periodically as you apply multiple updates from the NIS database.

1. Start ArcCatalog.
2. Make sure you are connected to the DEFAULT version of your product.
3. Right-click the production database (your database) and click Administration > Compress Database.
4. Click Yes on the Confirm Compress dialog box that appears.
5. Right-click the database and click Administration > Geodatabase Maintenance.

   The Geodatabase Maintenance dialog box appears.

6. Check the Analyze, Rebuild all indexes, and Shrink geodatabase check boxes.
7. Click OK.
8. Close ArcCatalog when maintenance is finished.

Tip:

The tempdb.mdf is used during implementation and continues to grow over time. You should periodically compact or remove the <Install directory>\Microsoft SQL Server\MSSQL.1\MSSQL\Data\tempdb.mdf.