locked
prereqchk complaining SQL server process memory allocation while 10GB has been allocated RRS feed

  • Question

  • The server: server 2012 R2 with 16GB RAM in total

    SQL server 2012 SP1 installed on it and the max server memory is set to 10240MB (10GB)

    When running prereqchk it sent a warning "SQL Server process memory allocation". It seems the checker cannot see the exact amount of ram allocated.

    Anything I have missed?

    Friday, November 22, 2013 3:28 AM

Answers

  • Did you limit minimum memory as well? I would set the minimum to 8192 and maximum to 13312 that is 8GB and 13GB which is about 50% and 80% of the total amount of RAM just in compliance with the requirements.

    Tim Nilimaa | Blog: http://infoworks.tv | Twitter: @timnilimaa

    • Marked as answer by TreeLeafs Friday, November 22, 2013 10:06 AM
    Friday, November 22, 2013 6:17 AM

All replies

  • Did you limit minimum memory as well? I would set the minimum to 8192 and maximum to 13312 that is 8GB and 13GB which is about 50% and 80% of the total amount of RAM just in compliance with the requirements.

    Tim Nilimaa | Blog: http://infoworks.tv | Twitter: @timnilimaa

    • Marked as answer by TreeLeafs Friday, November 22, 2013 10:06 AM
    Friday, November 22, 2013 6:17 AM
  • Thanks. I haven't tried that way. But it makes sense. So, the checker was actually looking at the minimum number instead of the maximum number.
    Friday, November 22, 2013 10:06 AM