Fix crashing of AAMail/DBMail with MS SQL Server

2018/04/08 13:43

AAMail/DBMail server supports using Microsoft SQL Server as database.

Problem:

However, when you have a large number of email account and domains in AAMail/DBMail. Then the MS SQL server uses much RAM on the server
and leads to using 100% RAM, which causes the SQL Server service to stop and results in crashing of AAMail/DBMail.


Solution:

Set MS SQL Server, maximum memory limit.

Example: 
If the server has 32 GB RAM, then set MS SQL Server maximum memory limit to 25 GB

This will prevent MS SQL Server service from being stopped and thus prevent any AAMail or DBmail server crashing

Related: