Home Forums SQL Server 2008 SQL Server 2008 - General Max Memory RE: Max Memory

  • September 11, 2013 at 5:40 pm

    #1649537

    Max server memory is just the upper limit that SQL is allowed to use. There's many cases where it won't reach that. Ones that immediately come to mind is it doesn't need that much memory or that that much memory is not available

    .

    Thanks Gail.

    We have 2 SQL Serve instances on same server, SQL Server 2008 R2 with SP1. The server has 16 GB RAM

    For both instances Max Memory is set 6GB and 4GB is left OS

    But instance1 is using 2.9 GB out of 6GB and instance2 is using 763 MB out of 6GB.

    Issue: PLE is dropping <5 minsfor every 15 to 20 mins and there is no much activity (no active sessions)on the server and also noticed CPU is going 80% when PLE drops to <5 mins

    Please advise why SQL Server is not utilizing memory allocated to it? By design, SQL Sever should use all of its max memory right?

    Thanks,

    Gary