0 Replies Latest reply on Jan 29, 2015 7:30 AM by yalla

    DPA hoa to resolve DPA indication on SQL SERVER Problem

    yalla

      Hi ,

      I have a SqlServer  2008 r2   under DPA

      in the RESOURCE TAB
      DPA  give me an ALERT about  Procedure Cache Hit Ratio

      Lookin on on online help i 've seen   :

       

      Percentage of time when SQL
      Server looks for an execution plan in the procedure cache and finds it for this instance.

       

      If this is low, try to write more reusable code and/or consider increasing the size of the
      procedure cache

       

      To see current metrics for
      the procedure cache, run the query:

       

      select * from
      master..sysperfinfo where object_name like '%Plan
      Cache%';

       

      But i cant' t find how increase this value , it seems is an automatic parameter