Post reply

Configure -g switch memory_to_reserve

  • October 2, 2012 at 9:53 am

    #265120

    Hi Guru,

    How to configure this -g switch? Do I need need to configure with integer value or just -g switch itself? Below is my MemtoLeave info on sql 2005 32bit:

    Total available mem,kb Max Free size, kb

    ---------------------------------------------------------

    306396 67008

    Please help,

    KongDBA

  • October 5, 2012 at 6:33 am

    #1546027

    Are you seeing issues on your instance that you think changing this value will help resolve? What specifically are you seeing?

    Here is how to change it:

    Using the SQL Server Service Startup Options

    -g memory_to_reserve

    Specifies an integer number of megabytes (MB) of memory that SQL Server will leave available for memory allocations within the SQL Server process, but outside the SQL Server memory pool.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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