I’m wondering if anyone has investigated or used any of the VBScripts under 'Microsoft Operations Manager | Rules | Advanced | Scripts', like 'SQL Multiple Instance Performance Data: Access'. We have multiple, named instances on several of our machines and are wondering if these scripts could help configure those instances.

Contributed By: Baelson Duque [MSFT]
If you check the knowledge for the SQL MP (Navigate to 'Rules | Processing Rule Groups' => click on 'Microsoft SQL Server') and you'll see instructions on the 'Configuration' section on exactly how to do this.

The rules are disabled by default and if you enable them, they will collect data for *ALL* SQL instances for that specific Perf Object. If you need to do it for specific instances and specific Perf Counters, that is also doable but requires you to make a copy of the script, create a new rule that uses your copy. In that copy of the script, you would need to modify the script a little.