We are trying to measure SQL Server Performance metrics. Is it better to record Performance Monitor (PerfMon) or DMV Dynamic Management Views to measure CPU, Memory, Buffer pages, etc? There are certain metrics, that PerfMon can measure which DMV cannot, and other way around DMV can measure certain things Perfmon can't. I am referring to common shared metrics.
In general, does Microsoft have best practice, to use Perfmon or DMV in SQL Server? I assume answer is Perfmon with remote computer, since measuring things with DMV takes lag/pressure on the central server. Perfmon can be utilized from remote server, and reduce load.