SDS secondary using up nearly all memory

[darrella]

We are using SDS for a production system, but the secondary getting ~99% memory utilisation, where more than half is with swap/page.

I've had a look through the SDS INI settings, but can't see anything obvious.

Are there any other config settings to manage this please ?

[allistar]

Hi Darrell,
The [PersistentDb] DiskCacheMaxSegments tells the database server how much memory the database engine can use for disk cache. This is in units of 64Mb, so a setting of "40" allows it to use about 2.5Gb. Check this setting and make sure it's not too high.

Regards,
Allistar.

[darrella]

Thanks Allistar, we'll give that a try.

DarrellD

[BeeJay]

Hi Darrell,

<snip>...

Never mind, it looks like Allistar beat me to the punch regarding DiskCacheMaxSegments setting. You should also check the DiskCacheBlocksPerSegment setting in the [PersistentDb] section in case the default 64M size has been increased.

Cheers,
BeeJay.

[JohnP]

Note that the default for [PersistentDb] DiskCacheMaxSegments is half of physical memory, so if you haven't specified it, the db will try to take up that much. If you have multiple databases, three for instance, they all try to take half of physical memory. In other words, the default assumes only one database per machine.