> ## Content Index
> Fetch the complete content index at: https://note.xdq.me/llms.txt
> Use this file to discover other available public pages before exploring further.

# Windows Server Core 配置 Windows Internal Database 内存限制
- URL: https://note.xdq.me/windows-server-core-pei-zhi-windows-internal-database-nei-cun-xian-zhi/
- Published: 2017-09-13T02:17:55.000Z
- Updated: 2026-10-03T03:00:43.000Z
- Author: xud6
- Tags: windows, wid, sql server, #Import 2026-10-03 02:45

##### 安装Microsoft ODBC Driver 13.1 for SQL Server

[http://go.microsoft.com/fwlink/?LinkId=825608](http://go.microsoft.com/fwlink/?LinkId=825608&ref=note.xdq.me)

##### 安装Microsoft Command Line Utilities 13.1 for SQL Server

[https://www.microsoft.com/en-us/download/details.aspx?id=53591](https://www.microsoft.com/en-us/download/details.aspx?id=53591&ref=note.xdq.me)

##### 执行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服务