• Hello,

    Gila already hit the direction you should take: useless metric and not what you are looking for.

    To better explain the reasons why that metric isn't getting you what you think it is please review this awesome post: https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-buffer-cache-hit-ratio/

    I spent some time a few weeks ago on this very same task to look up this setting as well. Utilizing information on this post I was able to see actual Buffer Cache Hit Ratio values.

    Hope that helps and good luck!

    Regards,

    Jeremy