Post reply

Memory

  • July 4, 2003 at 6:36 am

    #357929

    Hi,

    Just want to throw this open.

    I started a new job recently, one of our SQL servers runs Sage. SQL 2k, 1 GB Ram. This server is soley for Sage, but the memory allocation within SQL is fixed 750MB. Now I don't see the point in why this was setup like this. I would assume that it would be more beneficial to set the memory to dynamic, with 750mb as the max, as the app will not be consistently using 750mb.

    What would be the pros and cons for both methods?

    Thanks

    Ritch

    *I didn't do anything it just got complicated*


    "I didn't do anything it just got complicated" - M Edwards

  • July 7, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 7, 2003 at 9:50 am

    #464347

    Generally you use dynamic allocation unless you've enabled AWE, which requires fixed. That's on a machine that runs SQL exclusively. If you're forced to share it with another app, then you'd have to experiment, but probably dynamic is still ok, just set reasonable min/max.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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