We have instrumented the APM SQL Server enablement and are looking to see if there are any metrics that we can review in the Investigator to determine any potential issues and capacity.
We do see in the metrics in the following location:
(.*)\|Custom Metric Process \(Virtual\)\|Custom Metric Agent \(Virtual\) \(servername@port\)
Enterprise Manager\|Data Store\|SQL API:Average Response Time \(ms\)
But even when we see users coming in and extracting data, we don't see any metrics being logged in CA APM.