create server script to monitor mssql performance

Started by it_user1, January 29, 2019, 05:25:14 PM

Previous topic - Next topic

it_user1

Hi, i have a netxms installation on centos. I saw that with freetds i can run sql query directly from linux console. my goal is create a script on netxms server to run query on my mssql cluster.
i have already create a cluster node on netxms and i want to create a dci directly on cluster's object and not on cluster's node. it's possible?

thanks

Andrea

Victor Kirhenshtein

Hi,

you still need node to collect data from. On cluster level you can have only aggregated data. But you can define DCI on cluster level and associate it with cluster resource - that way it will be collected only on one node (which currently holds resource). If you need to do actual collection on other node (not cluster member) you can use "source node" option on DCI.

Best regards,
Victor