Windows Server Core 配置 Windows Internal Database 内存限制
安装Microsoft ODBC Driver 13.1 for SQL Server
http://go.microsoft.com/fwlink/?LinkId=825608
安装Microsoft Command Line Utilities 13.1 for SQL Server
https://www.microsoft.com/en-us/download/details.aspx?id=53591
执行sqlcmd
cd c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn
SQLCMD.EXE -E -S \\.\pipe\Microsoft##WID\tsql\query
显示高级选项
exec sp_configure 'show advanced option', '1';
reconfigure;
查询当前设置(max server memory行)
exec sp_configure;
go
设置内存限制为(2048MB)
exec sp_configure 'max server memory', 2048;
reconfigure with override;
go
退出
quit