You need to tune a block storage option database for calculations on a 32bit Essbase server. Identify the two starting point tuning steps that you might take (assuming no direct I/O).

The correct answer is A. Set Index Cache the size of the index file B. Set Data Cache to the size of 0.125 * pag file. Here are the best practices to tune a BSO database: - ACR (Average clustering Rate) should be as close to 1 as possible, launch a dense restructure to de-fragment the database - Block Size should be between 10 and 100KB (can be more on 64 bit systems) - Data cache should be…

Performance Tuning

Question

Options

ASet Index Cache the size of the index file
BSet Data Cache to the size of 0.125 * pag file
CSet Data File Cache to the size of .025 * data file
DReset sparse and dense dimensions to achieve a block size greater than 100KB

How the community answered

(45 responses)

A
71% (32)
C
20% (9)
D
9% (4)

Explanation

Here are the best practices to tune a BSO database: - ACR (Average clustering Rate) should be as close to 1 as possible, launch a dense restructure to de-fragment the database - Block Size should be between 10 and 100KB (can be more on 64 bit systems) - Data cache should be 12.5% of the pag files (B) - Index cache should be the same size as the ind files (A) - 1 Database per Application

Topics

#BSO tuning#index cache#data cache#32-bit server

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice