. NET open source MSSQL, REDIS surveillance product opserver MSSQL configuration

The configuration of MSSQL is relatively simple and consists of three main parts:

Default configuration (defaultconnectionstring), cluster configuration (clusters), single-instance configuration (instances)

DefaultConnectionString the node cannot be deleted by default and the value can be empty. Cluster and instance must exist, otherwise the SQL monitoring page does not render, specific configuration details can be viewed under the Opserver.core Project setting folder, Sqlsetting.cs file

{  "defaultconnectionstring":"Data source=192.168.11.210;initial catalog=test; User Id=sa; password=************",  "clusters": [    {      "name":"192.168.11.210",      "Refreshintervalseconds": -,      "nodes": [        {          "name":"192.168.11.220",          "connectionString":"Data source=192.168.11.220;initial catalog=test; User Id=sa; password=**********"        },        {          "name":"192.168.11.210",          "connectionString":"Data source=192.168.11.210;initial catalog=test; User Id=sa; password=**********"        }      ]    }  ],  "instances": [    {      "name":" Work",      "connectionString":"Data source=192.168.11.210;initial catalog=test; User Id=sa; password=**********"    }  ]}

It's so simple and convenient.

Just a few of these, really powerful.

. NET open source MSSQL, REDIS surveillance product opserver MSSQL configuration