SharePoint对DB执行操作时，报错为：There is insufficient system memory in resource pool ‘default’ ...

[SharePoint/SqlServer]对DB执行操作时，报错为：There is insufficient system memory in resource pool ‘default’ to run this query.

该问题为SQL Server 可使用内存不足，SQL默认大小为1024MB，需使用SQL语句执行扩容。

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'max server memory', 4096;

GO

RECONFIGURE;

GO