SQL Server Performance

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.

  1. 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
  2. MohammedU New Member

  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?

Share This Page