You can use the script below to limit the maximum amount of memory used by SQL 2008. While this can be important on a VPC where you have mulitple applications requesting memory, I would use the default settings on a dedicated SQL box. Replace xxx below with the maximum amount of memory in MB:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'max server memory', xxx;
GO
RECONFIGURE;
GO
Posted
Tue, Jan 5 2010 8:21 AM
by
DavidL