用Transact-SQL腳本來修改SQL SERVER最大最小記憶體設定項

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'min server memory', 2048;

GO

RECONFIGURE;

GO

sp_configure 'max server memory', 2560;

GO

RECONFIGURE;

GO

sp_configure 'show advanced options', 0;

GO

RECONFIGURE;

GO