Raul Gonzalez has started a new series around getting perfmon data into SQL Server. First up is logging perfmon counters:
Here you have the template I have used to create my Data Collector, you just need to write it down to a XML file and change some of the counters which are related to SQL Server.
When I say MSSQL$MSSQL2016, that is because this counter refer to a named instance called MSSQL2016. If that was the default instance, it’d be just “SQL Server”.
Example: <Counter>\SQL Server:Buffer Manager\Page life expectancy</Counter>
Once you adjust it, you’re good to go.
Click through for a sample data collector set and some instructions on logging counter values.