• HildaJ (6/19/2013)


    it seems that in some of my servers I see a constant high memory usage for both the OS and the SQL Server memory. In some instances the sql server memory reaches 95% and stays to that under for several hours.

    Normal, expected, documented behaviour.

    Any ideas where I can start reading and understanding what it all means and how to figure out what's causing the high memory usage?

    Chapter 4: https://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