On servers that have limited memory available, or have services other than the Wasp Cloud On-Premise software installed, we can reduce the amount of memory that the SQL Service will utilize. This generally improves performance of On-Premise as well as the other services.

Set the SQL memory utilization to 2GB:
a. Launch SQL Server Management Studio.
b. Set authentication to Windows Authentication
c. Connect.
d. At upper left, right-click [SERVER]\WASPDATA, Properties
e. At upper left, click Memory
f. Set the Maximum server memory (in MB) to 2048
g. OK

This change takes effect immediately; there is no need to restart SQL service or restart the server.