NetXMS Support Forum

English Support => General Support => Topic started by: it_user1 on January 29, 2019, 05:25:14 PM

Title: create server script to monitor mssql performance
Post by: it_user1 on January 29, 2019, 05:25:14 PM
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
Title: Re: create server script to monitor mssql performance
Post by: Victor Kirhenshtein on January 30, 2019, 11:49:53 AM
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