xud6的笔记本

wid

A 1 post collection


Windows Server Core 配置 Windows Internal Database 内存限制

 •  Filed under windows, wid, sql server
安装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
重启wid服务