Post reply

Memory Issue

  • April 18, 2014 at 7:43 am

    #292465

    I have win server 2008 r2 with Sql 2008 r2, IIS and few other application. Physical memory 16GB. Max memory setting for sql 12GB.

    In task manager Physical Memory = 95%

    Resource Monitor commit = 777,000 KB

    Is there any suggestion to bring Physical memory down to 80% on task manager?

  • April 18, 2014 at 7:45 am

    #1707072

    Set max server memory to a smaller value.

    -- Gianluca Sartori

  • April 18, 2014 at 9:04 am

    #1707104

    Thanks for ur reply, forgot to add:

    Resource Monitor commit (KB) = 777,000 w3wp.exe

  • April 18, 2014 at 9:22 am

    #1707108

    IIS is running in the same box as SQL Server, then again I suggest that you lower your max server memory

    -- Gianluca Sartori

  • April 18, 2014 at 9:24 am

    #1707110

    BTW, SQL Server will try to use all the memory in the box, so having 80% memory usage is not a good thing. Having mem usage > 90% is normal with SQL Server.

    -- Gianluca Sartori

Viewing 5 posts - 1 through 4 (of 4 total)

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