Post reply

Can some tell me if these settying on my server set correctly

  • May 4, 2009 at 12:40 pm

    #209086

    Can some tell me if these settying on my server set correctly

    Use AWE memory is checked

    Dynamic memory configuration: is checked

    Minimum server memory (in MB):0 in MB

    Maximum server memory (in MB):6115 in MB

    Index creation memory: 0

    Minimum memory per query (in KB)

    1024

    Thank you

    Julia

  • May 4, 2009 at 1:51 pm

    #988341

    It depends - how much memory does the server have? Is this a single instance server - in other words, are there other SQL Server instances running on this server?

    Is this a 32-bit system, or 64-bit?

    If 32-bit, do you have PAE enabled?

    Do you have the /3GB switch set in boot.ini?

    Are you running anything else on the server? For example, is it a DC - do you run SSIS packages, etc...

    All of the above will help determine if you have the memory configuration setup correctly.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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