SQL Server Performance

memory configuration

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by WingSzeto, May 2, 2007.

  1. WingSzeto Member

    I like someone to double check with the memory configuration so I know I am good to go.

    We have a IBM e-server with 1 CPU dual core and 6 Gbytes of RAM. CPU is one Xeon 2.80 Ghz dual core.

    We have W2k3 sp2 standard edition and SQL 2K5 Standard edition.

    In our boot.ini file, I have these two switches entered, /PAE /3GB. In SQL 2K5 memory configuration, I have min server memory set to 1024 and maximum server memory set to 3072. Did I set up correctly since I can only use up to 4 Gbytes?

    wingman
  2. satya Moderator

    Do you have any performance issues with the current setup?>

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. WingSzeto Member

    This is a new server and hasn't been put in production yet, but it will be in 3 days.


    quote:Originally posted by satya

    Do you have any performance issues with the current setup?>

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. satya Moderator

    Have you staged your application & database on this server?
    If not you can take help ofhttp://support.microsoft.com/kb/231619 SQLIOSIM to simulate such performance related information to check whether it can copeup or not.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. alexboy456 New Member

    is your server rinnoing 64bit version of windows or 32bit. as far as i remember the maximum amaount of memory windows server 2003 standard x386 is only 4gb see here. i fyou are running the x64 version then the limit is much higher. to use more than 4 gb ram in a x386 version of windows upi will need to upgrade to enterprise
  6. WingSzeto Member

    Thank for the information. The tool will help me a lot. But I just want to know your thought about the switch I put in the boot.ini in my orginial email.

    By having 6 Gbytes of RAM in the server, I will waste two 2 Gbytes since I am using Win 2K3 standard version. By using /PAE /3GB switches and min ser mem = 1024G and max ser mem =3072 in SQL memory configruation , SQL 2k5 can use up to 3 Gbytes of RAM. Am I correct on this? Should I not set the min and max and just let SQL dynamically assign? The server is only for SQL server and no other applicaitons.


    quote:Originally posted by satya

    Have you staged your application & database on this server?
    If not you can take help ofhttp://support.microsoft.com/kb/231619 SQLIOSIM to simulate such performance related information to check whether it can copeup or not.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. WingSzeto Member

    It is windows 2K3 standard wtih 32 bit. I posted another reply so please read that as well.

    quote:Originally posted by alexboy456

    is your server rinnoing 64bit version of windows or 32bit. as far as i remember the maximum amaount of memory windows server 2003 standard x386 is only 4gb see here. i fyou are running the x64 version then the limit is much higher. to use more than 4 gb ram in a x386 version of windows upi will need to upgrade to enterprise

Share This Page