Skip to Content
avatar image
Former Member

Memory Management for SQL Server DB

Hi!

We would like to increase the RAM-size of our Windows 2008 server from 6 GB to 10 GB.

Our phys_memsize parameter is currently set to value: 3500

Question:

Do we need to increase the size of SQL Server buffers, phys_memsize and other settings?

Via tcode ST04 I can see within Memory section:

Phys. Memory (MB): 6000

Current Memory: 2500

SQL memory Setting: FIXED

Any helpful information will be very appeciated

kind regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 24, 2010 at 02:57 PM

    > We would like to increase the RAM-size of our Windows 2008 server from 6 GB to 10 GB.

    > Our phys_memsize parameter is currently set to value: 3500

    >

    > Question:

    > Do we need to increase the size of SQL Server buffers, phys_memsize and other settings?

    This depends in which area you want to use the memory.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Markus Doehr

      Hi!

      I would like to share my new increased RAM size of 10 GB as follows:

      4.500 to SAP (setting parameter PHYS_MEMSIZE=4500)

      4.500 to DB

      1.000 I would let for OS

      Question

      How can I increase the value of SQL Server memory?

      Is this setting dynamic?

      When I look into the memory settings in SQL management Studio I see that

      minimum server memory is equal to maximum server memory and is set currentyl to value 2343.

      So I would like to set the value "4500" by setting this value under "minimum server memory" and under "mamixum server memory"

  • avatar image
    Former Member
    Aug 24, 2010 at 04:18 PM

    Hi Holger,

    If that is a dedicated sql server machine, you can give upto 6 GB and leave 4 GB for the OS.

    you can check data cache and proc cache ratio's and page life expectancy currently. it will give you an rough idea about how is the memory pressure on the system.

    Mush

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 25, 2010 at 01:22 PM

    Hello,

    Please check your parameters against this note.

    879941 Configuration Parameters for SQL Server 2005

    regards,

    John Feely

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      No, you don't have to restart the DB server. Its an online operation.

      After changing you can check by clicking running values under memory section of DB server properties.

      Thanks

      Mushtaq