Post reply

procedure cache hit rate vs buffer cache hit ratio

  • April 18, 2008 at 1:44 pm

    #380069

    procedure cache hit rate and buffer cache hit ratio

    is that a same thing?

  • April 18, 2008 at 3:31 pm

    #804611

    Procedure cache hit rate refers to how often a stored procedures execution plan is found in the procedure cache. Buffer cache hit rate refers to how often a request for data can be satisfied by pulling data pages from the buffer cache.

    Procedure cache is for stored procedure execution plan caching. Buffer cache is for data caching. See BOL for more info on these 2 items.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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