Processing Issues

Processing issues may be related to loads, queries, indexes, and table access.

• Too Many Indexes on Table
  Issues may occur when a table has too many indexes.
• Unexpectedly Long Loads or Queries
  Long loads or queries may cause issues.
• Load Fails on Number of Unique Values
  The number of unique values in a query may cause issues.
• Cannot Write to a Locked Table
  Locked tables may cause issues.
• Managing Write Lock Contention on a Table
  High contention for write locks on a table used by multiple users can impact processing, if most of the transactions are able to obtain the lock. The sample stored procedure in this section is an example of a method to manage the contention for a write lock on a table. This procedure does not eliminate the write lock contention on the table, but does manage the contention, so that transactions are able to get the write lock.
• Checkpoint Hints
  The default values for checkpoint time and recovery time are sufficient and do not need to be changed.