NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: create server script to monitor mssql performance  (Read 117 times)

it_user1

  • Newbie
  • *
  • Posts: 19
    • View Profile
create server script to monitor mssql performance
« 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
Logged

Victor Kirhenshtein

  • Lead Developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 6451
    • View Profile
Re: create server script to monitor mssql performance
« Reply #1 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
Logged