SQL Server Performance

Maximum memory per db

Discussion in 'ALL SQL SERVER QUESTIONS' started by JNandhi, Jul 4, 2012.

  1. JNandhi New Member

    Hi everyone,

    I have SQL Server 2005 32bit running on Server 2008 R2 with 30GB memory installed. We have a database running on it and it is only using 3.6GB of the 30 available. I have enabled the AWE option in the memory options. I have attached a screen grab of the memory settings page.

    All and any help would be gratefully accepted.

    Kind Regards,
    JNandhi

    Attached Files:

    JNandhi, Jul 4, 2012
    #1

  2. Luis Martin Moderator

    Luis Martin, Jul 4, 2012
    #2

  3. JNandhi New Member

    Hi Luis,

    Thank you for your reply. The OS is 64bit Server 2008 R2

    Kind Regards,
    JNandhi
    JNandhi, Jul 5, 2012
    #3

  4. Luis Martin Moderator

    AWE is not required and cannot be configured on 64-bit operating systems
    Luis Martin, Jul 5, 2012
    #4

  5. JNandhi New Member

    Ok I can take that option out, no problem, but it still only addresses 3.6GB of memory rather than the full 30GB.
    JNandhi, Jul 6, 2012
    #5

  6. JNandhi New Member

    JNandhi, Jul 6, 2012
    #6

Share This Page