Appinsight for SQL 2017 ??

mkirkpatrick

I am attempting to add a node running WINOS 2016 and SQL 2017.

I define the node to use WMI/ICMP and enter and test the credentials.  Works fine.  I then advance to CHOOSE RESOURCES.

On my SQL 2016 server, the APPINSIGHT for SQL monitor came up automatically. 

When I add the SQL 2017, APPINSIGHT for SQL does not appear.  Nor is it available to be added manually in the following screen.

Any help is appreciated.

mesverrum

Looking at that naming convention this is a member of a SQL cluster, i dont recall the details but I've had to hunt around a bit to find the correct address to monitor clusters with before.  There are several IP's you might have to try adding as nodes, off the top of my head I think there could be a windows individual server IP, sql fci cluster ip, aag listener address, and a few others that are less common.  If i remember correctly your best bet would be to add in the SQL database listener address as a node in orion and assign the appinisght template there.  In any case just keep adding them all in until you figure out which one shows up with the appinsight option in your environment.