Using appinsight for SQL, is there a way to display the counters of multiple instances under a same view.
I have a multiple named instances of SQL server installed on the same server.
I'd like to display memory related counters of those instances side by side to allow for an easier decision of which instance can have memory removed from and which one needs additional memory.
I am thinking page life expectancy, buffer cache hit ratio and total - target memory.
I cannot seem to find a view which allows to view counters from different instances side by side simultaneously.