This technical document guides the user through process of how to estimate their DXgrid datastore size on disk as well as how much system memory (RAM) is required to host the data when DSA starts up.
For CA Directory, the optimal RAM and datastore (Dxgrid db file) sizing is dependent on a number of factors. These factors include variables like the expected growth in data year on year as well as the amount of data which can be returned in a given request. As such, there is no specific formula or hardline approach as to what is required for CA Directory (DXgrid datastore).
Some best practices are as follows:
In summary, we cannot really determine the size requirements based upon......
e.g. "12 million users with 14 attributes each with a max 40 chars per attribute"
The best we can do is to provide 'rules of thumb'.
A general approach is as follows:
For example, if the "Total Datasize in MB" figure from dxloaddb was 900, and I expect that the number of users (and hence data) will double in the next 3 years I would choose a datastore of 1800MB. Multiplying 1800 by the figure 2.5 I arrive at a provisional physical memory requirement of 4500MB. The next logical physical memory size is 8GB so this would be recommended physical size for the DSA.
Once you perform a "dry run", you will notice the output something similar to:
DB Files Statistics:
Total Datasize in MB: 6052
Number of entries read: 12521481
Number of entries loaded: 12521481
Amount of db file padding in KB: 36851
Average number of entries per MB: 24489
This is the best method of calculating the size requirements of a DXgrid datastore.
Remember to allow headroom in the DXgrid datastore, in order to allow for new users being added. The amount of headroom will depend on the expected growth as well as the amount of time you wish to leave before having to extend the datastore size (see dxextenddb).