When I try to get sql performance counters from a server that has more than 1 instance of SQL I keep getting this error:
Cannot find any performance counter sets on the localhost computer that match the following: \MSSQL$DEV:Databases
Here is the code:
Get-Counter -ListSet SQLServer:Databases | Get-CounterHow can I change it to get the specific instance counter?