Log Store Optimization Techniques

Specify persistence to optimize data models for maximum performance.

  • Whenever possible, create a small log store to store static (dimension) data, and one or more larger log stores for dynamic (fact) data.
  • If you are using multiple log stores are being used for larger, rapidly changing, dynamic (fact) data, try to organize the stores on different RAID volumes.
  • The correct sizing of log stores is extremely important. See Sizing a Log Store in the Configuration and Administrators Guide.