Hi,
I am using DataMiner v9.6 CU6 and the VM has 8xCPU, 16GB memory and using MS SQL 2016 database on the same VM. There will be approx 20-30 elements on the cube.
Wanted to check what Skylines recommendation is with setting the minimum server memory and maximum server memory.
Hi,
For MSSQL databases the following guideline or formula can be used for a healthy memory distribution:
MSSQL = Total RAM – (DataMiner + Rest OS) – (DataMiner/2)
In other words, MSSQL should be allowed to use half of the available RAM after half the current DataMiner usage has been allotted for expansion, providing enough available in the first place e.g.
Total RAM: 16GB
DataMiner: 8GB
Rest OS: 2GB
-> 6GB left
Ideally: 50% of 8GB left for DM growth -> 4GB leaving 2GB for MSSQL
It’s impossible to say whether 2GB might ever be an issue, depending on how your DMA config changes. it’s just an illustration. It’s the proportions that you set after applying the calculation that are important. So you may require more or less RAM for MSSQL depending on that.
You should obviously do this exercise when your nominal DataMiner config has been set up.
Thanks Simon.
Thanks Simon. Is 2GB memory for MSSQL enough?
When looking at DM server with 16GB. At the moment without any SQL memory limits it is using 4.4GB. Will limiting the memory to 2GB cause any performance issues?
FYI This DM server is new and has no elements on it yet.