I have been looking for the best way to monitor SQL named instances and I have read several Thwack posts that suggest how to do this. I just want to make sure that my understanding is clear after having read those:
For each named instance on a system I will need to use one of the SQL Performance templates and specify the instance name for each component individually?
Assuming that is the case, I will need to modify approximately 34 components in the application specifying the instance for each instance of SQL. So if I have 3 instances that will be 102 components (34 components x 3 instances) that need to be modified in total?
If so, is there a more efficient way to accomplish this?
Thanks in advance for any feedback on this!