Zabbix监控 Windows SQL Server-ygqygq2
<?xml version="1.0" encoding="UTF-8"?> <zabbix_export><version>3.2</version>
<date>2018-02-11T06:11:01Z</date>
<groups>
<group>
<name>Templates</name>
</group>
</groups>
<templates>
<template>
<template>Template Windows LLD MSSQL</template>
<name>Template Windows LLD MSSQL</name>
<description># Desenvolvido por Diego Cavalcante - 06/12/2017
# Monitoramento Windows SQLServer</description>
<groups>
<group>
<name>Templates</name>
</group>
</groups>
<applications>
<application>
<name>MSSQL General</name>
</application>
<application>
<name>MSSQL Jobs Status</name>
</application>
<application>
<name>MSSQL Memory</name>
</application>
<application>
<name>MSSQL Services</name>
</application>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<items>
<item>
<name>Version</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>discovery.mssql.data</key>
<delay>86400</delay>
<history>15</history>
<trends>0</trends>
<status>0</status>
<value_type>1</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Version of SQLServer.</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>MSSQL is running</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>net.tcp.port[,{$MSSQLPORT}]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL General</name>
</application>
</applications>
<valuemap>
<name>Service state</name>
</valuemap>
<logtimefmt/>
</item>
<item>
<name>Processor Time (%)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\Process(sqlservr)\% Processor Time]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>%</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\Process(sqlservr)\% Processor Time]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Memory in Use</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\Process(sqlservr)\Private Bytes]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Memory in Use
perf_counter[\Process(sqlservr)\Private Bytes]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Memory</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Buffer Cache Hit Ratio (%)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Buffer cache hit ratio]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>%</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Buffer Manager\Buffer cache hit ratio]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Memory</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Checkpoint Pages por (SEG)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Checkpoint pages/sec]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>p/sec</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Buffer Manager\Checkpoint pages/sec]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Database Pages</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Database pages]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\SQLServer:Buffer Manager\Database pages]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Lazy Writes por (SEG)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Lazy writes/sec]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>p/sec</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Buffer Manager\Lazy writes/sec]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Page Life Expectancy</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Page life expectancy]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>s</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Buffer Manager\Page life expectancy]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Target Pages</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Target pages]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Buffer Manager\Target pages]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Total pages</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Total pages]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>1</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Buffer Manager\Total pages]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Total> <type>7</type>
<snmp_community/>
<multiplier>1</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Databases(_Total)\Data File(s)> <delay>3600</delay>
<history>15</history>
<trends>90</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1024</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Total>
perf_counter[\{$MSSQLINST}:Databases(_Total)\Data File(s)> <inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL General</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Total> <type>7</type>
<snmp_community/>
<multiplier>1</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Databases(_Total)\Log File(s)> <delay>3600</delay>
<history>15</history>
<trends>90</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1024</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>日志的大小
perf_counter[\{$MSSQLINST}:Databases(_Total)\Log File(s)> <inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL General</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Total of connections in the databases</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:General Statistics\User Connections]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>总的数据库连接
perf_counter[\{$MSSQLINST}:General Statistics\User Connections]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Lock Waits por (SEG)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Locks(_Total)\Lock Waits/sec]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>p/sec</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Locks(_Total)\Lock Waits/sec]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Grants Pending Memory</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Memory Manager\Memory Grants Pending]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Memory Manager\Memory Grants Pending]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Memory</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Cache Memory</name>
<type>7</type>
<snmp_community/>
<multiplier>1</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Memory Manager\SQL Cache Memory (KB)]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1024</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Cache Memory
perf_counter[\{$MSSQLINST}:Memory Manager\SQL Cache Memory (KB)]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Memory</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Memory Reserved</name>
<type>7</type>
<snmp_community/>
<multiplier>1</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Memory Manager\Target Server Memory (KB)]</key>
<delay>3600</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1024</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:Memory Manager\Target Server Memory (KB)]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Memory</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>Erros por (SEG)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:SQL Errors(_Total)\Errors/sec]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>p/sec</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:SQL Errors(_Total)\Errors/sec]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>SQL Compilations por (SEG)</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:SQL Statistics\SQL Compilations/sec]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>p/sec</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>perf_counter[\{$MSSQLINST}:SQL Statistics\SQL Compilations/sec]</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Statistics</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
</item>
<item>
<name>SQL Server Integration Services 10.0</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>service.info</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Service: MsDtsServer100
Name: SQL Server Integration Services 10.0
Description: Provides management support for storing and running SSIS packages.</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Services</name>
</application>
</applications>
<valuemap>
<name>MSSQL Service</name>
</valuemap>
<logtimefmt/>
</item>
<item>
<name>SQL Server Agent {$MSSQLAGENT}</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>service.info[{$MSSQLAGENT}]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Service: SQLSERVERAGENT
Name: SQL Server Agent ({$ MSSQLAGENT})
Description: Performs tasks, monitors SQL Server, triggers alerts, and allows the automation of some administrative tasks.</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Services</name>
</application>
</applications>
<valuemap>
<name>MSSQL Service</name>
</valuemap>
<logtimefmt/>
</item>
<item>
<name>SQL Server {$MSSQLSERVER}</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>service.info[{$MSSQLSERVER}]</key>
<delay>300</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Service: MSSQLSERVER
Name: SQL Server ({$ MSSQLSERVER})
Description: Offers storage, processing, and controlled access to data and fast transaction processing.</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Services</name>
</application>
</applications>
<valuemap>
<name>MSSQL Service</name>
</valuemap>
<logtimefmt/>
</item>
</items>
<discovery_rules>
<discovery_rule>
<name>MSSQL Databases</name>
<type>7</type>
<snmp_community/>
<snmp_oid/>
<key>discovery.mssql.databases</key>
<delay>3600</delay>
<status>0</status>
<allowed_hosts/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<delay_flex/>
<params/>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<filter>
<evaltype>0</evaltype>
<formula/>
<conditions/>
</filter>
<lifetime>1</lifetime>
<description>MSSQL数据库服务器发现</description>
<item_prototypes>
<item_prototype>
<name>{#MSSQLDBNAME} Number of Connections</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>discovery.mssql.data</key>
<delay>600</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Number of MSSQL Database Connections - {#MSSQLDBNAME}</description>
<inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<application_prototypes>
<application_prototype>
<name>MSSQL database info - {#MSSQLDBNAME}</name>
</application_prototype>
</application_prototypes>
</item_prototype>
<item_prototype>
<name>{#MSSQLDBNAME} Status</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>discovery.mssql.data</key>
<delay>600</delay>
<history>7</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>MONITOR o Status to DATE MINIMUM - {# MOUNT}</description>
<inventory_link>0</inventory_link>
<applications/>
<valuemap>
<name>MSSQL Databases Status</name>
</valuemap>
<logtimefmt/>
<application_prototypes>
<application_prototype>
<name>MSSQL database info - {#MSSQLDBNAME}</name>
</application_prototype>
</application_prototypes>
</item_prototype>
<item_prototype>
<name>{#MSSQLDBNAME} Database> <type>7</type>
<snmp_community/>
<multiplier>1</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Databases({#MSSQLDBNAME})\Data File(s)> <delay>3600</delay>
<history>15</history>
<trends>90</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1024</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Detects Total Bank>
perf_counter[\{$MSSQLINST}:Databases({#MSSQLDBNAME})\Data File(s)> <inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<application_prototypes>
<application_prototype>
<name>MSSQL database info - {#MSSQLDBNAME}</name>
</application_prototype>
</application_prototypes>
</item_prototype>
<item_prototype>
<name>{#MSSQLDBNAME} Log> <type>7</type>
<snmp_community/>
<multiplier>1</multiplier>
<snmp_oid/>
<key>perf_counter[\{$MSSQLINST}:Databases({#MSSQLDBNAME})\Log File(s)> <delay>3600</delay>
<history>15</history>
<trends>90</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1024</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Total Log File>
perf_counter[\{$MSSQLINST}:Databases({#MSSQLDBNAME})\Log File(s)> <inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<application_prototypes>
<application_prototype>
<name>MSSQL database info - {#MSSQLDBNAME}</name>
</application_prototype>
</application_prototypes>
</item_prototype>
</item_prototypes>
<trigger_prototypes>
<trigger_prototype>
<expression>{Template Windows LLD MSSQL:discovery.mssql.data.last(0)}>0</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>{#MSSQLDBNAME}({ITEM.LASTVALUE})is down on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description>Sqlserver
The status of the database {# mssqldbname} is {item.lastvalue}
Status possible.
0 ⇒ online.
1 ⇒ catering
2 ⇒ recovering
3 ⇒ recovery pending
4 ⇒ suspect
5 ⇒Emergency
6 ⇒ offline
7 ⇒ not exist</description>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
</trigger_prototypes>
<graph_prototypes>
<graph_prototype>
<name>MSSQL Database> <width>900</width>
<height>200</height>
<yaxismin>0.0000</yaxismin>
<yaxismax>100.0000</yaxismax>
<show_work_period>0</show_work_period>
<show_triggers>1</show_triggers>
<type>0</type>
<show_legend>1</show_legend>
<show_3d>0</show_3d>
<percent_left>0.0000</percent_left>
<percent_right>0.0000</percent_right>
<ymin_type_1>0</ymin_type_1>
<ymax_type_1>0</ymax_type_1>
<ymin_item_1>0</ymin_item_1>
<ymax_item_1>0</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>0</sortorder>
<drawtype>5</drawtype>
<color>00C800</color>
<yaxisside>0</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Databases({#MSSQLDBNAME})\Data File(s)> </item>
</graph_item>
<graph_item>
<sortorder>1</sortorder>
<drawtype>5</drawtype>
<color>0099CC</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Databases({#MSSQLDBNAME})\Log File(s)> </item>
</graph_item>
</graph_items>
</graph_prototype>
<graph_prototype>
<name>MSSQL Number of Connections in {#MSSQLDBNAME}</name>
<width>900</width>
<height>200</height>
<yaxismin>0.0000</yaxismin>
<yaxismax>100.0000</yaxismax>
<show_work_period>0</show_work_period>
<show_triggers>1</show_triggers>
<type>0</type>
<show_legend>1</show_legend>
<show_3d>0</show_3d>
<percent_left>0.0000</percent_left>
<percent_right>0.0000</percent_right>
<ymin_type_1>0</ymin_type_1>
<ymax_type_1>0</ymax_type_1>
<ymin_item_1>0</ymin_item_1>
<ymax_item_1>0</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>0</sortorder>
<drawtype>5</drawtype>
<color>0099CC</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>discovery.mssql.data</key>
</item>
</graph_item>
</graph_items>
</graph_prototype>
</graph_prototypes>
<host_prototypes/>
</discovery_rule>
<discovery_rule>
<name>MSSQL Jobs</name>
<type>7</type>
<snmp_community/>
<snmp_oid/>
<key>discovery.mssql.jobs</key>
<delay>3600</delay>
<status>0</status>
<allowed_hosts/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<delay_flex/>
<params/>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<filter>
<evaltype>0</evaltype>
<formula/>
<conditions/>
</filter>
<lifetime>1</lifetime>
<description>SQL Server Jobs Discovery</description>
<item_prototypes>
<item_prototype>
<name>Job {#MSSQLJOBNAME} Status</name>
<type>7</type>
<snmp_community/>
<multiplier>0</multiplier>
<snmp_oid/>
<key>discovery.mssql.data</key>
<delay>3600</delay>
<history>15</history>
<trends>30</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<delta>0</delta>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<formula>1</formula>
<delay_flex/>
<params/>
<ipmi_sensor/>
<data_type>0</data_type>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>Monitora Status dos Jobs SQLSERVER.</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>MSSQL Jobs Status</name>
</application>
</applications>
<valuemap>
<name>MSSQL Jobs Status</name>
</valuemap>
<logtimefmt/>
<application_prototypes/>
</item_prototype>
</item_prototypes>
<trigger_prototypes>
<trigger_prototype>
<expression>{Template Windows LLD MSSQL:discovery.mssql.data.last(0)}=0</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Job {#MSSQLJOBNAME} ({ITEM.LASTVALUE}) on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description>SQLServer
Job Status {#MSSQLJOBNAME} is {ITEM.LASTVALUE}
Possible Status:
0 = Failure
1 = Success
2 = Repeat
3 = Canceled
4 = In Progress
5 = Never Run</description>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
<trigger_prototype>
<expression>{Template Windows LLD MSSQL:discovery.mssql.data.last(0)}=2</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Job {#MSSQLJOBNAME} ({ITEM.LASTVALUE}) on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>1</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
<trigger_prototype>
<expression>{Template Windows LLD MSSQL:discovery.mssql.data.last(0)}=3</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Job {#MSSQLJOBNAME} ({ITEM.LASTVALUE}) on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
<trigger_prototype>
<expression>{Template Windows LLD MSSQL:discovery.mssql.data.last(0)}=5</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Job {#MSSQLJOBNAME} ({ITEM.LASTVALUE}) on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>3</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
</trigger_prototypes>
<graph_prototypes/>
<host_prototypes/>
</discovery_rule>
</discovery_rules>
<httptests/>
<macros/>
<templates/>
<screens/>
</template>
</templates>
<triggers>
<trigger>
<expression>{Template Windows LLD MSSQL:net.tcp.port[,{$MSSQLPORT}].last(0)}=0</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>MSSQL ({ITEM.LASTVALUE}) is not running on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description>MSSQL Port is down</description>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags/>
</trigger>
<trigger>
<expression>{Template Windows LLD MSSQL:service.info[{$MSSQLAGENT}].count(#3,0,gt)}=3</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>SQL Server Agent {$MSSQLAGENT} ({ITEM.LASTVALUE}) is not running on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description>Service: SQLSERVERAGENT
Name: SQL Server Agent ({$ MSSQLAGENT})
Description: Performs tasks, monitors SQL Server, triggers alerts, and allows the automation of some administrative tasks.</description>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags/>
</trigger>
<trigger>
<expression>{Template Windows LLD MSSQL:service.info.count(#3,0,gt)}=3 and {Template Windows LLD MSSQL:service.info.last()}<>255</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>SQL Server Integration Services 10.0 ({ITEM.LASTVALUE}) is not runnig on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description>Service: SQLSERVERAGENT
Name: SQL Server Agent ({$ MSSQLAGENT})
Description: Performs tasks, monitors SQL Server, triggers alerts, and allows the automation of some administrative tasks.</description>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags/>
</trigger>
<trigger>
<expression>{Template Windows LLD MSSQL:service.info[{$MSSQLSERVER}].count(#3,0,gt)}=3</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>SQL Server {$MSSQLSERVER} ({ITEM.LASTVALUE}) is not runnig on {HOST.NAME}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description>Service: MSSQLSERVER
Name: SQL Server ({$ MSSQLSERVER})
Description: Offers storage, processing, and controlled access to data and fast transaction processing.</description>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags/>
</trigger>
</triggers>
<graphs>
<graph>
<name>MSSQL Memory Usage</name>
<width>900</width>
<height>200</height>
<yaxismin>0.0000</yaxismin>
<yaxismax>100.0000</yaxismax>
<show_work_period>1</show_work_period>
<show_triggers>1</show_triggers>
<type>0</type>
<show_legend>1</show_legend>
<show_3d>0</show_3d>
<percent_left>0.0000</percent_left>
<percent_right>0.0000</percent_right>
<ymin_type_1>0</ymin_type_1>
<ymax_type_1>0</ymax_type_1>
<ymin_item_1>0</ymin_item_1>
<ymax_item_1>0</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>0</sortorder>
<drawtype>2</drawtype>
<color>FC6EA3</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\Process(sqlservr)\Private Bytes]</key>
</item>
</graph_item>
<graph_item>
<sortorder>1</sortorder>
<drawtype>2</drawtype>
<color>A54F10</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Memory Manager\SQL Cache Memory (KB)]</key>
</item>
</graph_item>
<graph_item>
<sortorder>2</sortorder>
<drawtype>2</drawtype>
<color>2774A4</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Buffer cache hit ratio]</key>
</item>
</graph_item>
<graph_item>
<sortorder>3</sortorder>
<drawtype>2</drawtype>
<color>6C59DC</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Memory Manager\Memory Grants Pending]</key>
</item>
</graph_item>
<graph_item>
<sortorder>4</sortorder>
<drawtype>2</drawtype>
<color>AC8C14</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Memory Manager\Target Server Memory (KB)]</key>
</item>
</graph_item>
</graph_items>
</graph>
<graph>
<name>MSSQL Statistics</name>
<width>900</width>
<height>200</height>
<yaxismin>0.0000</yaxismin>
<yaxismax>100.0000</yaxismax>
<show_work_period>1</show_work_period>
<show_triggers>1</show_triggers>
<type>0</type>
<show_legend>1</show_legend>
<show_3d>0</show_3d>
<percent_left>0.0000</percent_left>
<percent_right>0.0000</percent_right>
<ymin_type_1>0</ymin_type_1>
<ymax_type_1>0</ymax_type_1>
<ymin_item_1>0</ymin_item_1>
<ymax_item_1>0</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>0</sortorder>
<drawtype>0</drawtype>
<color>6C59DC</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Checkpoint pages/sec]</key>
</item>
</graph_item>
<graph_item>
<sortorder>1</sortorder>
<drawtype>0</drawtype>
<color>AC8C14</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Database pages]</key>
</item>
</graph_item>
<graph_item>
<sortorder>2</sortorder>
<drawtype>0</drawtype>
<color>611F27</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:SQL Errors(_Total)\Errors/sec]</key>
</item>
</graph_item>
<graph_item>
<sortorder>3</sortorder>
<drawtype>0</drawtype>
<color>F230E0</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Lazy writes/sec]</key>
</item>
</graph_item>
<graph_item>
<sortorder>4</sortorder>
<drawtype>0</drawtype>
<color>5CCD18</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Locks(_Total)\Lock Waits/sec]</key>
</item>
</graph_item>
<graph_item>
<sortorder>5</sortorder>
<drawtype>0</drawtype>
<color>BB2A02</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Page life expectancy]</key>
</item>
</graph_item>
<graph_item>
<sortorder>6</sortorder>
<drawtype>0</drawtype>
<color>5A2B57</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\Process(sqlservr)\% Processor Time]</key>
</item>
</graph_item>
<graph_item>
<sortorder>7</sortorder>
<drawtype>0</drawtype>
<color>89ABF8</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:SQL Statistics\SQL Compilations/sec]</key>
</item>
</graph_item>
<graph_item>
<sortorder>8</sortorder>
<drawtype>0</drawtype>
<color>7EC25C</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Buffer Manager\Target pages]</key>
</item>
</graph_item>
<graph_item>
<sortorder>9</sortorder>
<drawtype>0</drawtype>
<color>274482</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:General Statistics\User Connections]</key>
</item>
</graph_item>
</graph_items>
</graph>
<graph>
<name>MSSQL Total> <width>900</width>
<height>200</height>
<yaxismin>0.0000</yaxismin>
<yaxismax>100.0000</yaxismax>
<show_work_period>1</show_work_period>
<show_triggers>1</show_triggers>
<type>0</type>
<show_legend>1</show_legend>
<show_3d>0</show_3d>
<percent_left>0.0000</percent_left>
<percent_right>0.0000</percent_right>
<ymin_type_1>0</ymin_type_1>
<ymax_type_1>0</ymax_type_1>
<ymin_item_1>0</ymin_item_1>
<ymax_item_1>0</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>0</sortorder>
<drawtype>5</drawtype>
<color>00CC00</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Databases(_Total)\Data File(s)> </item>
</graph_item>
<graph_item>
<sortorder>1</sortorder>
<drawtype>5</drawtype>
<color>DD0000</color>
<yaxisside>1</yaxisside>
<calc_fnc>7</calc_fnc>
<type>0</type>
<item>
<host>Template Windows LLD MSSQL</host>
<key>perf_counter[\{$MSSQLINST}:Databases(_Total)\Log File(s)> </item>
</graph_item>
</graph_items>
</graph>
</graphs>
<value_maps>
<value_map>
<name>MSSQL Databases Status</name>
<mappings>
<mapping>
<value>0</value>
<newvalue>online</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>restoration</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>recovering</newvalue>
</mapping>
<mapping>
<value>3</value>
<newvalue>pending recovery</newvalue>
</mapping>
<mapping>
<value>4</value>
<newvalue>suspect</newvalue>
</mapping>
<mapping>
<value>5</value>
<newvalue>emergency</newvalue>
</mapping>
<mapping>
<value>6</value>
<newvalue>offline</newvalue>
</mapping>
<mapping>
<value>7</value>
<newvalue>not exist</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>MSSQL Jobs Status</name>
<mappings>
<mapping>
<value>0</value>
<newvalue>failure</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>Sucess</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>Repeat</newvalue>
</mapping>
<mapping>
<value>3</value>
<newvalue>Canceled</newvalue>
</mapping>
<mapping>
<value>4</value>
<newvalue>In progress</newvalue>
</mapping>
<mapping>
<value>5</value>
<newvalue>Never performed</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>MSSQL Service</name>
<mappings>
<mapping>
<value>0</value>
<newvalue>Initiated</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>Paused</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>Start Pending</newvalue>
</mapping>
<mapping>
<value>3</value>
<newvalue>Pause Pending</newvalue>
</mapping>
<mapping>
<value>4</value>
<newvalue>Continue Pending</newvalue>
</mapping>
<mapping>
<value>5</value>
<newvalue>Stop Pending</newvalue>
</mapping>
<mapping>
<value>6</value>
<newvalue>Stopped</newvalue>
</mapping>
<mapping>
<value>7</value>
<newvalue>Unknown</newvalue>
</mapping>
<mapping>
<value>255</value>
<newvalue>Unknown</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>Service state</name>
<mappings>
<mapping>
<value>0</value>
<newvalue>Down</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>Up</newvalue>
</mapping>
</mappings>
</value_map>
</value_maps>
</zabbix_export>
页:
[1]