Post reply

Performance issues - memory???

  • August 12, 2009 at 8:20 am

    #137248

    I have a server with 4GB memory running sql server 2000 enterprise edition. Users are reporting very poor performance. In Enterprise Manager, the memory is set to dynamically configure sql server memory with min. set at 2048 and max set at 4096 and minimum query memory set at 1024.

    Are these setting ok or what can I change to improve performace?

    Any assistance would be appreciated.

    Regards

    Toukey

  • August 12, 2009 at 9:39 am

    #1038085

    Do you have AWE enabled? /3gb set?

    That max is too high. You're telling SQL it can use all the memory on the server and leave absolutely nothing for the OS. With 4 GB memory in the server I would set /3GB, not set AWE and put the max memory to 3 GB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 12, 2009 at 12:14 pm

    #1038195

    Ok - I will give that a try.

    Thank you.

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

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