Database performance considerations

• For an Oracle database, take instrumentation snapshots (AWR snapshots or statspack snapshots at level 10) before and after integritycheck commands and integritycheckandload commands.
• Generate database instrumentation reports and resolve any performance problems. For an Oracle database, these reports are AWR reports or statspack reports. For SQL Server, the reports are DMV snapshots. Navigate to Server Tools > Info Pages. For an Oracle database, go to the Oracle AWR or Oracle Statspack page. For SQL Server, go to the SQL Server DMV Snapshot page. Download load information from the Load History page. Use all of this information to investigate performance problems in integrity checks and data loading.
• Navigate to Server Tools > Info Pages > Database Statistics. Download and archive a copy of the database catalog statistics before each database import attempt. Designing appropriate statistics collection into all database import code substantially improves the ability of Guidewire to advise you on performance issues related to database import.

Example commands are shown below.

• Web service method example

  var batchProcessID = TableImportAPI.updateStatisticsOnStagingTablesAsBatchProcess()

• Command prompt tool example

  table_import -password password -updatedatabasestatistics -batch