AutoSPInstaller Error – Insufficient system memory in resource pool ‘default’

AutoSPInstaller is a great project that facilitates Automated SharePoint installation including Sharepoint 2010, 2013, 2016 and 2019.

Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm.

Error:

Deploying Web Application via AutoSPInstaller when the script failed

Error: New-SPWebApplication: There is insufficient system memory in resource pool ‘default’ to run this query.

AutoSPInstaller – Error – Insufficient system memory

Don’t be fooled, this is a SQL Server related error, and not IIS.

If you open SQL Server Management Studio on your database server, and open the Logs, you will see the following errors:

AutoSPInstaller – Error – SQL Server Error Message

Solution:

Open SQL Server Management Studio > Right Click on the Instance > Select Properties > Select Memory tab.

AutoSPInstaller – Error – SQL Maximum Server Memory

You will see that the Maximum Server Memory is 512MB which is way too low.

Set the Maximum Memory as at least 2GB shy of the total server memory, e.g 14GB if total server memory is 16GB.

AutoSPInstaller – Error – Set SQL Maximum Server Memory

Restart the SQL Server Service, and you wont have this issue again.

SQL Server 2012 Insufficient Memory

Needed to be able to convert a SQL Server 2014 database to SQL Server 2012 to give to an external third party who can only run SQL Server 2012.

Scripted out the database and data in SQL Server 2014.

Went to SQL Server 2012 to run the script and encountered the error:

---

Insufficient Memory to continue the execution of the program.

---

Script was over 30MB.

To resolve I had to use SQLCMD to execute the script.

sqlcmd -S SQLServer2012\2012 -i D:\export.sql