performance counter prepare values

  • Hi all

    Please tell me the which values are best prepared value for given below memory objects

    Memory

    Parameter

    Total memory=

    SQL Cache Memory=

    Lock Memory=

    Optimizer Memory=

    Connection Memory=

    Granted WorkSpace Memory=

    Memory Grants Pending=

    Memory Grants Success=

    Cache Details:

    Cache Hit Ratio=

    Cache Used/Min=

    Cache Count=

    Cache Pages=

    Scheduled Jobs:

    Job Status=

    Run date & time=

    Job Time=

    Retries Attempted=

    Please anyone can tell me the above performance counters prepared values

    thanks advance

  • multiple posts please, see here =http://www.sqlservercentral.com/Forums/Topic1659397-391-1.aspx

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

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

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