Post reply

Memory utilization

  • October 7, 2012 at 8:15 pm

    #265497

    SQL Server (2008) is using 92% of the memory. out of 56 GB SQL using 51.6 GB

    How to find out memory consuption for each process, is there any other memory consumers outside of the buffer tool

    thanks

  • October 8, 2012 at 1:49 am

    #1546589

    Firstly, that's entirely normal.

    If you want to reduce SQL's memory usage, set max server memory to a sensible value. If you leave it at default, you're telling SQL that it can use every bit of the memory on the server.

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

  • October 9, 2012 at 12:59 am

    #1547031

    You should put forward your issue in more details.

    If you meant that your SQL Server cannot use all memory on the server, you can check memory consumption in windows task manager or performance monitor. This is if your SQL Server memory usage is not limited through "max server memory option".

  • October 9, 2012 at 7:59 am

    #1547226

    Do you mean MemUsage indicator per process as in sp_who2's CPUTime and DiskIO?

    I found this article on MSDN.

    Michael Gilchrist
    Database Specialist
    There are 10 types of people in the world, those who understand binary and those that don't. 😀

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

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