Zabbix------Custom key monitoring Windows SQL Server

1 used the official template, location in Https://www.zabbix.org/wiki/Zabbix_Templates, feel a bit more, and after the addition of {$SQL 1} is still no such service, so decided to write a bit of custom, By the way, the main reference online this eldest brother, http://mayulin.blog.51cto.com/1628315/514509/

2 Windows Add Monitoring item generally with PerfCounter, this is a counter, used to monitor the performance parameters of the system, give me the overall feeling is Zabbix for Windows a bit like for SNMP, and perfcounter like a MIB library administrator, The parameters are like OID

method to get the PerfCounter parameter:

1 cmd input typeperf-qx-o typeperf.txt put it out, you can not export it, just not easy to see, feel

So my fedora opened this typeperf.txt file, I chose a database because of the official problem may be SQL Server too old, in short, it is estimated to change a lot of things.

I chose this parameter \sqlserver:databases (hnyleomsserver) \log File (s) used Size (KB), the parentheses are my database name, I already know the PerfCounter parameters

2 Add Key,key in Web interface can write this, perf_counter["perf parameters"]

This example is perf_counter["\sqlserver:databases (hnyleomsserver) \log File (s) used Size (KB)"]

And then go to latest data and see the numbers.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/74/6D/wKiom1Yct8bhsr3aAACPGIhMxj4227.jpg "title=" Screenshot from 2015-10-13 15-50-03.png "alt=" Wkiom1yct8bhsr3aaacpgihmxj4227.jpg "/>

3 and the official comparison of the next

perf_counter["\mssql${$SQL 3}:D atabases (_total) \log File (s) size (KB)" This is the day to size of the official third interface, if the hnyleomsserver is brought in, Found only the front is not the same, and the tail of a used, I came to test

Test again, a little busy, we should know how to change it, a better way to have two, a direct web copy a template, modify the corresponding key, and another in the zabbix_agentd.conf.d/add conf file, the content format for

Parameters of the Perfcounter=perf

I haven't tried it either. Wait for my template to be good, then send another copy.

This article is from the "Learning Path of Kai Learning" blog, please make sure to keep this source http://qixue.blog.51cto.com/7213178/1702557

Zabbix------Custom key monitoring Windows SQL Server