Thursday, June 02, 2011

Limit maximum memory available to Sql-Server

Here is a script that can be used to limit the maximum memory available to Sql-Server

EXEC sys.sp_configure N'max server memory (MB)', N'8192'
GO
RECONFIGURE WITH OVERRIDE
GO

Where 8192 is 8gb in the above example

No comments: