shahin37
asked on
Performance monitor VS sys.dm_os_performance_counters
Hi Experts ,
Does anyone knows why some counters values are different in performance monitor and sys.dm_os_performance_coun ters . and how can I make them equal.
For example buffer cache hit ratio is almost 100 in performance monitor but in DMV is different . or Checkpoint pages/sec is 0 in performance monitor and in DMV is more than 80000.
Regards
Does anyone knows why some counters values are different in performance monitor and sys.dm_os_performance_coun
For example buffer cache hit ratio is almost 100 in performance monitor but in DMV is different . or Checkpoint pages/sec is 0 in performance monitor and in DMV is more than 80000.
Regards
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Vitor
Also confirm that you are watching for the same instances in both counters.