Limiting the Amount of RAM used by SQL Server

Limiting the Amount of RAM used by SQL Server

This article contains a video that shows how to limit the amount of RAM used by the SQL server. 

This is important when Netaphor SiteAudit™  is running on the same machine as the SQL server. That's because the SQL server will use as much RAM as available and does not release this memory unless needed by another application. The SiteAudit Monitor service requires a minimum of 4GB of RAM to function properly. So when the SQL server and the Netaphor SiteAudit Monitor service run on the same machine, it is best to limit SQL memory consumption.

By default, SQL is configured to use as much available memory as it needs, as shown below.

In the following example, SQL is given 4 GB RAM for operation.