How to Calculate the RAM required for a DataStore

First Step - Find the size of the database(s)

For this calculation you will need the following pieces of information:

1. The size of the DataStoreDSX database, not including any unused space.

2. The size of any other databases on the SQL instance (e.g. an integration database containing KYC data or the DSXWorkflow database).

 

To find the size of a database, not including the unused space look at the properties of the database and then subtract the "Space Available" property from the "Size" property. For the below example the size of the database is 16MB - 5.09MB = 10.91MB

Second Step - Calculate the RAM required

The formula used to calculate the RAM required is as follows:

RAM Required =

20% of largest database on the instance (normally this is the DataStore database)

+

20% of the sum of all databases on the instance (not including system DBs)

+

2GB (for the OS)

 

Example

If a SQL server has the following databases:

DataStore = 100GB

KYCData = 20GB

 

RAM required =

20% of 100

+

20% of (100 + 20)

+

2

= 46GB