Post reply

memory setting

  • August 6, 2003 at 1:47 am

    #160611

    confuse with the setting for memory. Hope somebody can help to clarify my confusion

    1.) what is the difference between using "use fixed memory sizes" and setting min and max memory size to same value with "set working set" = 1?

    2.) should I configure "set working set" = 1 if the server already configured with "use fixed memory size" ?

    thanks & regards,

    Ann

  • August 7, 2003 at 8:08 pm

    #469111

    Let me rephrase my question:

    1.) For memory setting, should I select "Dynamically configure SQL memory" or "Use a fixed memory size(MB)" ?

    2.) If I select "use a fixed memory size", should I check the checkbox for "Reserved physical memory for SQL Server" ? What is the implication of doing so ?

    thanks

    Ann

  • August 7, 2003 at 8:23 pm

    #469112

    quote:

    1.) For memory setting, should I select "Dynamically configure SQL memory" or "Use a fixed memory size(MB)" ?

    It depends. In most cases, I would suggest to use dynamical memory configuration. The advantage is SQL Server will take as much as memory it likes for better performance and releases memory if other processes need memory.

    quote:

    If I select "use a fixed memory size", should I check the checkbox for "Reserved physical memory for SQL Server" ? What is the implication of doing so ?

    "Reserved physical memory for SQL Server" is EM is equal to 'set working set size' to 1 in sp_configure. Do not set set working set size if you are allowing SQL Server to use memory dynamically. Before setting set working set size to 1, set both min server memory and max server memory to the same value, the amount of memory you want SQL Server to use. It reserves physical memory spaces accoring to memory setting for SQL Server and does not swap out SQL Server pages even if they can be used more readily by another process when SQL Server is idle.

    For more information, refer to "Server Memory Options" in BOL.

  • August 7, 2003 at 10:10 pm

    #469115

    So if I choose "Use a fixed memory size", does that mean that I should consider set the option "Reserved physical memory for SQL Server" ?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply