• ALZDBA (2/23/2010)


    These is one big NONO with your configuration:

    Minimum server memory(in MB): 102400

    Maximum server memory(in MB): 102400

    Don't set the same value for min and max server memory ! It confuses sqlserver memory manager !

    With 64-bit you don't need to enable AWE because it can directly access all of your ram (+2TB)

    FYI, Per this article: This says to set both Min and Max memory to the same value:

    http://www.sqlmag.com/Articles/ArticleID/37890/pg/2/2.html