HELP SQL user experience monitor

I am in the process of creating a amp SQL query to monitor the polling completion of the SolarWinds Servers.

Here is the SQL that I plan to use.

select pollingcompletion

from engines

where engineid = '14'

I will end up making one for each of my pollers.

I have tried to make an SQL user experience monitor with no Success. I have attached a Pic of where I am, and not working.

Find more posts tagged with

Hi Aliendan,

I just tested it here on my APM and it works.

Do you get an error message when you click on Test while you edit the component?

Are you sure the Initial Catalog is the correct name of your database?

Thanks,

Yann

Do I have to assign to the monitor to the SQL server? If so how do I handle clusters?

Yes. You have to assign the application monitor to the SQL server you want to execute the query against.

As for clusters, it depends on if you want to monitor the nodes of the cluster or the cluster itself.

If you want to monitor the nodes of the cluster, just add them as nodes in Orion and then assign the application monitor to each node.

If you want to monitor the cluster, just add the cluster's IP as a node in Orion and then assign the application monitor to it