This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Total and Target server memory

Maybe I'm not seeing this correctly.

I have a server with 32Gb RAM. To my mind this is 'Total server Memory'

On that server I have SQL Server 2012 installed. This is capped at 16Gb. I consider this 'Target server Memory' for the instance.

I would love to know if the server is at or near or exceeeds the Target over a period of time.

This does not appear to be what SAM is showing me though. For one server it reports the Total Server memory at 252mb.

Or maybe I'm not undertstanding these two metrics.

Parents
  • Could you post a screen shot of the resource you are looking at so we can help explain what you are seeing?

  • Maybe a visual from one of my test instances can hep....

    There are three metrics:

    The first value shows how much memory SQL is currently using not what is physically available. (This value could be quite low compared to the available memory in the machine if for example SQL has restarted recently.)

    The second value shows how much SQL would like to use to operate optimally.

    The third is essentially the difference between the dynamic memory available to SQL and how much it is actually using.

    You can actually click on each of the metric names to get the details page which contains more info about the specific metric (see second screen shot below)

    pastedImage_0.png

    pastedImage_4.png

Reply
  • Maybe a visual from one of my test instances can hep....

    There are three metrics:

    The first value shows how much memory SQL is currently using not what is physically available. (This value could be quite low compared to the available memory in the machine if for example SQL has restarted recently.)

    The second value shows how much SQL would like to use to operate optimally.

    The third is essentially the difference between the dynamic memory available to SQL and how much it is actually using.

    You can actually click on each of the metric names to get the details page which contains more info about the specific metric (see second screen shot below)

    pastedImage_0.png

    pastedImage_4.png

Children
No Data