Improving the Performance of Business Rules and Calculation Scripts-CSDN博客

Check that compression settings are still present. In EAS, expand the application and database. Right-click on the database > Edit > Properties > Storage tab. Check that your "Data compression" is not set to "No compression" and that "Pending I/O access mode" is set to "Buffered I/O". Sometimes the compression setting can revert to "no compression", causing the rapid growth of the data files on disk.
On the Statistics tab, check the "Average clustering ratio". This shoud be close to 1. If it is not, restructure you database, by right-clicking on it and choosing "Restructure...". This will reduce any fragmentation caused by repeated data import and export. Fragmentation will naturally reduce performance over time, but this can happen quite quickly when there are many data loads taking place.
Check the caches and block sizes.
1. Recommended block size: 8 to 100Kb
2. Recommended Index Cache:
  Minimum=1 meg
  Default=10 meg
  Recommendation=Combined size of all ESS*.IND files if possible; otherwise as large as possible given the available RAM.
3. Recommended Data File Cache:
  Minimum=8 meg
  Default=32 meg
  Recommendation=Combined size of all ESS*.PAG files if possible; otherwise as large as possible given the available RAM, up to a maximum of 2Gb.
  
  NOTE this cache is not used if the database is buffered rather than direct I/O (Check “Storage” tab). Since all Planning databases are buffered, and most customers use buffered for native Essbase applications too, this cache setting is usually not relevant.
4. Recommended Data Cache:
  Minimum=3 meg
  Default=3 meg
  Recommendation=0.125 * Combined size of all ESS*.PAG files, if possible, otherwise as large as possible given the available RAM.
  
  A good indication of the health of the caches can be gained by looking at the “Hit ratio” for the cache on the Statistics tab in EAS. 1.0 is the best possible, lower means lower performance.
Check system resources:
1. Recommended virtual memory setting (NT systems): 2 to 3 times the RAM available. 1.5 times the RAM on older systems.
2. Recommended disk space:
  A minimum of double the combined total of all .IND and .PAG files. You need double because you have to have room for a restructure, which will require twice the usual storage space whilst it is ongoing.