12 responses

  1. Cecil
    June 5, 2012

    This is brilliant! Thanks for all the blogs and hard work!

  2. Farhan Soomro
    June 5, 2012

    Hi Jon,
    I ran the script on one of the system where I am having memory pressure issues, I see in output some of the records RESOURCE_MEMPHYSICAL_LOW but both indicatorProcess and IndicatorSystem are 0. Wondering what it is
    Thanks.

  3. Cristopher Benge
    June 5, 2012

    Woot, now I’m famous! Seriously, great follow up to the prior (very informative) blog on max server memory. Ironically, the day after I contacted you this very question [of appropriate max server memory estimating] appeared in the internal DL’s and having your blog as a reference was invaluable to the discussion. Nice work, Jonathan.

  4. jonathan
    June 5, 2012

    Hey Farhan,

    I am going to email you a different script so we can maybe see what is triggering those events.

  5. jonathan
    June 5, 2012

    Hey Mike,

    The IndicatorsProcess means that the SQL Server instance is under internal memory pressure, so you have something internal to SQL that is triggering the Resource Monitor to log the memory pressure. That is something I would look into, to find out what is causing the internal pressure.

  6. Dave
    August 29, 2013

    I’m also seeing a large number of RESOURCE_MEMPHYSICAL_LOW in which both “indicator” columns are zero, like Farhan. In my cases, it’s not obvious that the servers in question are under memory pressure.

    I would, however, like to know what it means. Has anyone found the answer?

  7. Allen McGuire
    January 31, 2014

    Just to confirm, if the IndicatorsProcess is >0, the memory pressure is being reported from the instance the DMV is being run on, correct? I have a multi-instance server and one instance is reporting RESOURCE_MEMPHYSICAL_LOW with IndicatorsProcess = 2.

    • Jonathan Kehayias
      February 5, 2014

      Yes it is instance specific.

  8. John Amitrone
    March 12, 2014

    Jonathon,

    Thank you for all the great blog posts. After running the script on several servers, I have also found one server producing results like Farhan Soomro’s reply above. There are RESOURCE_MEMPHYSICAL_LOW records with both IndicatorProcess and IndicatorSystem returning 0. I would like to understand why and if the script you shared with Farhan may have determined a cause? Thanks.

    • Jonathan Kehayias
      April 7, 2014

      Without taking a memory dump of the process you can’t figure it out for certain, but generally from dump analysis it is related to pool level pressure and there are no indicators for this in the XML currently.

Leave a Reply

 

 

 

Back to top
mobile desktop