Post reply

Memory usage high - sqlservr.exe

  • June 12, 2015 at 7:35 am

    #299050

    Hi Guys,

    I have a SQL 2014 Enterprise instance on a 2 node cluster where 215 GB out of 256 GB total memory is allocated to SQL Server. I see sqlservr.exe is using 26 GB of memory (task manager) and is taking more day by day. Now the total memory used for SQL is 215 GB (Max memory) + 26 GB = 241 GB. Can you guys put some light on how to troubleshoot this issue.

    Many thanks in advance.

  • June 12, 2015 at 7:57 am

    #1805045

    Normal, expected behaviour. Nothing to troubleshoot, nothing wrong.

    Don't use Task Manager to look at SQL's memory usage, it lies. Use perfmon counters, total 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

  • June 12, 2015 at 8:41 am

    #1805074

    Thanks.

    What is using upto 26 GB on top of max memory (215gb) pre-allocated to this instance? It's increasing by almost 1gb per week where it was 25gb last week.

    Perfmon counters:

    Total server memory- 215gb

    Stolen server memory- 15gb

    Available memory- 10.5 gb

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

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