-- 打开SQL高级选项设置
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
-- 设置最大内存为 512M
USE master
EXEC sp_configure 'max server memory (MB)',15000
RECONFIGURE WITH OVERRIDE
-- 打开SQL高级选项设置
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
-- 设置最大内存为 512M
USE master
EXEC sp_configure 'max server memory (MB)',15000
RECONFIGURE WITH OVERRIDE