Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters
Buffer cache hit ratio This means what is the percentage that SQL Server had the data in cache and did not have to read the data from disk. Ideally you want this number to be as close to 100 as pos…