Home Forums SQL Server 2005 Administering "Total Server Memory" & "Target Server Memory" are very low RE: "Total Server Memory" & "Target Server Memory" are very low

  • Hi, at first I just thought that perhaps SQL simply wasn't needing to use more memory. Its ok for target/ total to be less than physical RAM.

    Then you mentioned the paging. Are you certain it is SQL server that is causing the paging?

    What are other counters saying like "page life expectancy" and "buffer cache hit ratio?" If these numbers look normal ~ +300 and +90, respectively, you may not have any problems from a SQL server perspective. Basically, what does the big picture say? Target=Total < Physical in itself isn't a bad thing...

    Anyhow, I'm sure you have resolved the situation by now. So, I would like to hear what became of this!