Post reply

Counter

  • September 21, 2010 at 3:13 am

    #146974

    Hi,

    Memory Grants Outstanding & Memory Grants Pending counters are aloways shows as zero in the performance counter.

    Can anyone elaborate what does not mean and what is the normal level and high level counts ?

    Thanks in Advance.

  • September 21, 2010 at 10:50 am

    #1225047

    Here is one which explains Memory counters

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • September 21, 2010 at 11:42 am

    #1225099

    Adiga (9/21/2010)

    Here is one which explains Memory counters

    Hi,

    Thanks for your reply.

    Memory Grants Outstanding

    Number of processes that have successfully acquired workspace memory grant. High value of this counter indicates peak user activity.

    Its says that It will show the count of number of processes that have successfully acquired work space but it always shows as zero even at peak hours of production.

    that's why i have posted this question on the forum. can anyone elaborate this ?

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

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