Opserver configuring REDIS, SQL Server monitoring

Brief introduction

Opserver is an open source monitoring solution for stack Overflow, published by Stack exchange and based on. NET Framework build. Open Source Address: https://github.com/opserver/Opserver

Use

GitHub after the source code is compiled and published to IIS, you need to first modify the configuration information in the Opserver/config directory (as modified by the template):

The first is Securitysettings.config (remove the. example suffix after editing):

1 <?XML version= "1.0" encoding= "Utf-8"?>2 <!--configured to be accessible to everyone -3 <securitysettingsprovider= "Alladmin">4     <Internalnetworks>5         <!--the address under this node does not require authentication -6         <Networkname= "SE Internal"CIDR= "127.0.0.1" />7     </Internalnetworks>8 </securitysettings>

Enable Redis monitoring

Edit the Redissettings.json as follows:

1 {2"Allservers": {3"Name": "All",4"Instances": [5{"Name": "All servers have instances", "Port": "99999"}6         ]7     },8"Servers": [9         { Ten"Name": "192.168.1.222" , One"Instances": [  A{"Name": "Redis_1", "Port": "10001" }, -            ] -         }, the         { -"Name": "127.0.0.1", -"Instances": [  -             {  +"Name": "Redis_1",  -"Port": "6379" +             }, A             {  at"Name": "Redis_master",  -"Port": "6380", -"Password": "123456"//auth -             }, -             {  -"Name": "Redis_slave_1",  in"Port": "6381" }, -             {  to"Name": "Redis_slave_2",  +"Port": "6382" -             }, the            ] *         } $     ]Panax Notoginseng}

Here the machine opens 4 redisserver:6379-6382,6380 (master)/6381/6382 mainly from the cluster.

Within the allservers, is the global instance information in the instance configured under the Servers node (Redis in the configuration is actually on, only for demonstration purposes), monitoring:

Click an instance to view Redis detailed monitoring information:

Enable SQL Server monitoring

Edit Sqlsettings.json:

1 {2 //default connection string, instance not configured ConnectionString, replace already name $ServerName $3 " defaultconnectionstring": "Data source= $ServerName $;initial catalog=master;integrated security=sspi;",4 "Instances": [5         { 6 "name": "MYDB",7 " connectionString": "server=127.0.0.1; User Id=user; password=123456; Trusted_connection=false ",8         },9     ]Ten}

Monitoring:

Top, the first few query statements can be viewed according to the criteria:

Connections, you can view the current Activity link and click to view specific information:

To view the execution plan:

It ' s All

Opserver configuring REDIS, SQL Server monitoring