SQL Server Performance

Log in or Sign up

Min and Max Memory setting for SQL Server 2008 on Windows 2008 ?

Discussion in 'SQL Server 2008 General DBA Questions' started by varun_3g, May 5, 2009.

varun_3g New Member

Hi all

I would like to know whats the best parctise for min and max memory settings for SQL 2k8 on Windows 2k8 for an OLTP system, is it same as Memory-4GB (4 GB reserved for OS)? Does WIndows 2008 OS require more then 4GB or is it ok for SQL to dynamically allocate memory for itself.

Thanks Everyone

varun_3g, May 5, 2009

#2
MohammedU New Member

Read the BOL topic...Effects of min and max server memory
http://msdn.microsoft.com/en-us/library/ms180797.aspx
http://msdn.microsoft.com/en-us/library/ms177455.aspx
http://msdn.microsoft.com/en-us/library/ms178067(SQL.90).aspx
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!1003.entry?sa=759788303

MohammedU, May 6, 2009

#3
satya Moderator

I would say it requires sometime to identify and analyze the performance behaviour of the server, unless it is required setting MIN & MAX memory is not recommended, which is another best practice.
What kind of performance hit you are getting with the existing & default settings?

satya, May 7, 2009

#4

(You must log in or sign up to reply here.)

Share This Page