Post reply

Server is ignoring Max Server Memory

  • November 19, 2013 at 7:05 am

    #285361

    Hi,

    I have a production server that has been having weird slowdowns. I suspect memory.

    I have set the 'max server memory' setting to use 6 gig (of 10).

    But when I check the memory usage in task manager I get -

    Physical memory

    total 10239

    cached 629

    available 879

    free 285

    using a total of 8.95 gig ! When I check it is the SQL server service using 7,045,508k

    What the heck? I thought max server memory @ 6 gig meant SQL would only use 6 gig?

  • November 19, 2013 at 7:19 am

    #1667388

    Max server memory limits the buffer pool. SQL uses additional memory over and above the buffer pool for things like thread stacks, backup buffers, linked server drivers and other. It's usually a fairly small amount.

    If SQL's using too much memory, reduce max server memory.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 19, 2013 at 7:40 am

    #1667396

    Will do. thanks.

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

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