Post reply

memory settings

  • August 19, 2003 at 9:30 am

    #176315

    Has anyone done any comparison on sqlserver with different memory setting to choose the best memory configuration? any thoughts or ideas would be greatly appreciated

    TIA

  • August 19, 2003 at 9:51 am

    #470442

    SQL 2K does a good job on it's own for the most part. Sometime setting a hard upper limit to allow NT to have some room is a good idea. I don't have strong feelings on the upper limit but I am sure some folks do.

  • August 20, 2003 at 9:46 am

    #470621

    Thanks for the response. But can you be a bit more specific how sql server 2000 helps in determining the best mem configuration

  • August 20, 2003 at 10:07 am

    #470626

    SQL 2000 has many enhancements in area of memory allocation. Based on your requirement you can set the parameter. If you go through the enhancements you should be able to notice which ones can be used. For example setting AWE etc...

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

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