Microsoft Operations Management Suite (OMS) is now able to collect performance data at a rate of up to every 10 seconds.
Configuration is super simple.
Simply add or remove the counters you wish to have collected and the data will start pouring in for review. The only challenge I see here is how to collect SQL related data since the SQL instance name comprises part of he object name. In order to test how this is going to be handled, I added the following counters just taking a guess (and hoping something was done to simplify the process) as to how OMS might handle this situation:
I found a bunch of these events for MSSQL and MSSQL$ in the event log shortly after attaching the SQL machine to OMS:
A few minutes afterwards, I found the performance data with the object name MSSQL$OMDB inside Search within the OMS Portal:
This means the SQL data will have to be treated a little bit differently from a collection perspective, but it is manageable. Next steps would be to explore if there is a way to programmatically interface with OMS in order to configure these counters. For now, most performance counters are very easily configured and collected for analysis in OMS!