SQL Server - Missing CPU data for Standard Edition

[Trovalo]

Feature Request

Find the best way to get CPU usage information and add them to an existing measurement or on a new one.
In the v1 queries, this has a measurement on his own, called 'CPU (%)', code here.

As of now, CPU data are present only for enterprise and developer edition of SQL Server, the idea is to get it also for Standard and Express editions.

Proposal:

For what I've found so far the best way is to get the data from the ring buffer (table sys.os_dm_ring_buffer) as is done in the queries v1.

Current behavior:

As of now, in the measurement 'sqlserver_performance' you can find the counter 'CPU usage %', with a record for each application pool and workload group. If no UD (user-defined) resource pool has been configured you will find "internal" and "default"
Resource groups:

• internal - The internal pool represents the resources consumed by the SQL Server itself. (meaning resource used by SQL Server itself to work)
• default and UD - gathers data about workloads (ie: consumption of queries sent by an application)

The Problem
In order to track default and UD resource pools, Resource Governor must be enabled on the instance, but it is available only on the enterprise edition of SQL Server (and also Developer edition).

This means that CPU data can be tracked only on Enterprise and Developer edition of SQL Server (and not for Standard and Express).

Desired behavior:

Having CPU data for regardless of the SQL Server edition.

Use case:

This is crucial information for monitoring, missing it for some edition of SQL Server is not nice