zabbix_export: version: '5.4' date: '2021-11-21T21:48:02Z' groups: - uuid: 7df96b18c230490a9a0a9e2307226338 name: Templates templates: - uuid: 87514ee6c2f449ada3989b60337eaacb template: 'App MSSQL 2008-2016 WSFC' name: 'App MSSQL 2008-2016 WSFC' description: | ## Overview ``` Requirements: ``` 1. Zabbix 3+ Install instrucitons: https://github.com/hermanekt/MSSQL-2008-2016-Multi-instance-with-WSFC groups: - name: Templates items: - uuid: 2733463983354064be7a8c5c8b289166 name: 'Host name of SQL Node' key: agent.hostname delay: 60s history: 30d trends: '0' value_type: CHAR tags: - tag: Application value: 'MSSQL STATUS' triggers: - uuid: b8f91358f6984569b303c919db4e51ce expression: '(last(/App MSSQL 2008-2016 WSFC/agent.hostname,#1)<>last(/App MSSQL 2008-2016 WSFC/agent.hostname,#2))>0' recovery_mode: RECOVERY_EXPRESSION recovery_expression: '(last(/App MSSQL 2008-2016 WSFC/agent.hostname,#1)<>last(/App MSSQL 2008-2016 WSFC/agent.hostname,#2))>0' name: 'Active SQL Node was changed {HOST.NAME}' priority: AVERAGE manual_close: 'YES' - uuid: c8b77331cf104d9480c0db7371946604 name: 'SQL Server Default Service State - MSSQLSERVER' key: 'service_state[MSSQLSERVER]' delay: 30s value_type: FLOAT valuemap: name: 'Windows service state' tags: - tag: Application value: 'MSSQL STATUS' triggers: - uuid: b0cead95023c4d348ce2772e802862a5 expression: | last(/App MSSQL 2008-2016 WSFC/service_state[MSSQLSERVER])>0 and last(/App MSSQL 2008-2016 WSFC/service_state[MSSQLSERVER])<255 name: 'SQL Default Instance: Service state (MSSQLSERVER) is not running' priority: HIGH - uuid: 3662900c22754ecbb16b619b4c2d0f5b name: 'SQL Agent Default Instance: Service State - SQL Agent (MSSQLSERVER)' key: 'service_state[SQLServerAgent]' delay: 60s history: 7d valuemap: name: 'Windows service state' request_method: POST tags: - tag: Application value: 'MSSQL STATUS' triggers: - uuid: 16af29fc57ab458e9da188162ca65313 expression: | last(/App MSSQL 2008-2016 WSFC/service_state[SQLServerAgent])>0 and last(/App MSSQL 2008-2016 WSFC/service_state[SQLServerAgent])<255 name: 'SQL Default Instance: Service state SQL Agent (MSSQLSERVER) is not running' priority: HIGH description: 'SQL Agent Default Instance: Service State - SQL Agent (MSSQLSERVER)' discovery_rules: - uuid: 9f3b25cd66754e81afe63445c06db9d5 name: 'Database Discovery' key: mssql.db.discovery delay: 1h filter: conditions: - macro: '{#DBNAME}' value: '@MSSQL Databases for discovery' formulaid: A item_prototypes: - uuid: 6bf638ca3fad4ef18f5f614388f0df8a name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Active Transactions' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Active Transactions"]' value_type: FLOAT description: 'Number of active transactions for the database.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: a6e8b53533644132a9fb4caba601a4af name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Data File Size' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Data File(s) Size (KB)"]' value_type: FLOAT units: B description: 'Cumulative size (in kilobytes) of all the data files in the database including any automatic growth. Monitoring this counter is useful, for example, for determining the correct size of tempdb.' preprocessing: - type: MULTIPLIER parameters: - '1024' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: cb14cff19e2243d6bf1535446ed53cf9 name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Bytes Flushed/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Bytes Flushed/sec"]' value_type: FLOAT units: B description: 'Total number of log bytes flushed per second. Useful for determining trends and utilization of the transaction log.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: 990bf8ea82424adeb350055189d21668 name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log File Size' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log File(s) Size (KB)"]' value_type: FLOAT units: B description: 'Cumulative size (in kilobytes) of all the transaction log files in the database.' preprocessing: - type: MULTIPLIER parameters: - '1024' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: f34c25185a254edb889e5368c9e77490 name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log File Used Size' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log File(s) Used Size (KB)"]' value_type: FLOAT units: B description: 'The cumulative used size of all the log files in the database.' preprocessing: - type: MULTIPLIER parameters: - '1024' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: a2489d3d608b49fb8b0170ff1368662f name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Flushes/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Flushes/sec"]' value_type: FLOAT description: 'Number of log flushes per second.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: b6842626bc31411abfb0326a4ddcb6ec name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Flush Waits/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Flush Waits/sec"]' value_type: FLOAT description: 'Number of commits per second waiting for the log flush.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: 10c6e9732c854e35815f83ed664e9a68 name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Flush Wait Time' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Flush Wait Time"]' value_type: FLOAT units: ms description: 'Total wait time (in milliseconds) to flush the log. On an AlwaysOn secondary database, this value indicates the wait time for log records to be hardened to disk.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: 2cd540af5d994bb7bb6bf28db7e20150 name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Growths' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Growths"]' value_type: FLOAT description: 'Total number of times the transaction log for the database has been expanded.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: 9b0442d041794b0582236ed6407f226c name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Shrinks' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Shrinks"]' value_type: FLOAT description: 'Total number of times the transaction log for the database has been shrunk.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: 3173c39d5ea844099eb586021000101e name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Log Truncations' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Log Truncations"]' value_type: FLOAT description: 'The number of times the transaction log has been shrunk.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: b821ae51ebc44f2a80e4c5893727182a name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Percent Log Used' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Percent Log Used"]' value_type: FLOAT units: '%' description: 'Percentage of space in the log that is in use.' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: afcaf8d14064442f812ed118cf3a64c9 name: 'SQL Server, Instance {#INST}, DB {#DBNAME}: Transactions per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases({#DBNAME})\Transactions/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL DATABASE' - uuid: 76481e1e36154b45bd83f3194e115ffe name: 'SQL Error Log' key: mssql.errorlog delay: 1h item_prototypes: - uuid: 748a39101f9f46f2962c066b7c8e6e7c name: 'SQL Server, Instance {#INST}: Error Log File (LOGCount)' type: ZABBIX_ACTIVE key: 'log.count[{#ERRORLOG},Error|Failed,"UTF-16"]' tags: - tag: Application value: 'MSSQL Error Log' trigger_prototypes: - uuid: 139a5654c4f74fee9fa0bb2ceb373dc7 expression: 'sum(/App MSSQL 2008-2016 WSFC/log.count[{#ERRORLOG},Error|Failed,"UTF-16"],5m)>0' name: 'Errors in {#INST} ERRORLOG' priority: WARNING - uuid: aa3f4c0167ec4d48a29ea6fe38230399 name: 'SQL Server, Instance {#INST}: Error Log File (LOG)' type: ZABBIX_ACTIVE key: 'log[{#ERRORLOG},Error|Failed,"UTF-16"]' trends: '0' value_type: LOG tags: - tag: Application value: 'MSSQL Error Log' - uuid: 3cd634f90b444c9987a322c543625ada name: 'Instance Discovery' key: mssql.instance.discovery delay: 1h item_prototypes: - uuid: b96bbfe8f94e4ba496942b3ff05d7e67 name: 'SQL Server, Instance {#INST}: Access Methods\Page Splits/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Access Methods\Page Splits/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL ACCESS METHODS' - uuid: d78d69016bee4a5d90e46a08391c647c name: 'SQL Server, Instance {#INST}: Bytes Received from Replica/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Bytes Received from Replica/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: d93d1872118a4a98883ad9f0ac40e245 name: 'SQL Server, Instance {#INST}: Bytes Sent to Replica/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Bytes Sent to Replica/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 02d3cbce08a04dadafe1c55e850d72f2 name: 'SQL Server, Instance {#INST}: Bytes Sent to Transport/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Bytes Sent to Transport/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 4036746558094f0ca4b7b582663a8927 name: 'SQL Server, Instance {#INST}: Flow Control/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Flow Control/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 4f32e2ae20254ec4a94ff6f2f4f2ca9e name: 'SQL Server, Instance {#INST}: Flow Control Time (ms/sec)' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Flow Control Time (ms/sec)"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 96ac31ea1d8740ed95fda233f8fb2694 name: 'SQL Server, Instance {#INST}: Receives from Replica/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Receives from Replica/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 10385d59e46a42a8a701cd6b137db97a name: 'SQL Server, Instance {#INST}: Resent Messages/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Resent Messages/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: bc4832fc9fd54a308fea870f1a45a377 name: 'SQL Server, Instance {#INST}: Sends to Replica/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Sends to Replica/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: e694a62c73ad47fd8a35cc2c36bfd14b name: 'SQL Server, Instance {#INST}: Sends to Transport/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Availability Replica(_Total)\Sends to Transport/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: ef05ba2a15a64d67beda4882f1b5fb06 name: 'SQL Server, Instance {#INST}: Buffer Manager\Page life expectancy' key: 'perf_counter["\{#PERFCOUNTERNAME}:Buffer Manager\Page life expectancy"]' tags: - tag: Application value: 'MSSQL MEMORY' - uuid: 79725d2bf792472a83eed40fbf6cdcdd name: 'SQL Server, Instance {#INST}: Buffer Manager\Page reads/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Buffer Manager\Page reads/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL MEMORY' - uuid: 6595f4a0e17149e6bff4b9ff0b8e5bc2 name: 'SQL Server, Instance {#INST}: Buffer Manager\Page writes/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Buffer Manager\Page writes/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL MEMORY' - uuid: ce0e6182d1d24c88bbb97c9b0f6a9d20 name: 'SQL Server, Instance {#INST}: Database Flow Control Delay' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Database Flow Control Delay"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 6fdbcabcdc054d9f932fed1352fab4aa name: 'SQL Server, Instance {#INST}: Database Flow Controls/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Database Flow Controls/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 8655458c3fbc44f9801cc7e5b15cd2a3 name: 'SQL Server, Instance {#INST}: File Bytes Received/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\File Bytes Received/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 55762f0c8c8048faba4aaadcbd376887 name: 'SQL Server, Instance {#INST}: Group Commits/Sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Group Commits/Sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 1b1adc6ee97e499eaba0f8f160073ecd name: 'SQL Server, Instance {#INST}: Group Commit Time' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Group Commit Time"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 635dd70140354278b23c501f5c327bfa name: 'SQL Server, Instance {#INST}: Log Bytes Compressed/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Bytes Compressed/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: a1d5c4f2645640d09af3c74f7d81d92b name: 'SQL Server, Instance {#INST}: Log Bytes Decompressed/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Bytes Decompressed/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: c09ff37761a4424a9e04ab464449cb9b name: 'SQL Server, Instance {#INST}: Log Bytes Received/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Bytes Received/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 19478f1780c1429898ffe5f10459254c name: 'SQL Server, Instance {#INST}: Log Compression Cache hits/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Compression Cache hits/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: a3b97e59bf224337a1965b1ae50e1b8d name: 'SQL Server, Instance {#INST}: Log Compression Cache misses/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Compression Cache misses/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 2ce82e6f72d340b3b00e4cca5844bb66 name: 'SQL Server, Instance {#INST}: Log Compressions/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Compressions/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: ea121e7afa7a484ebd1bfe91e0751f2a name: 'SQL Server, Instance {#INST}: Log Decompressions/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Decompressions/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: c3d2184498b24f0faa7858703805f5c3 name: 'SQL Server, Instance {#INST}: Log remaining for undo' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log remaining for undo"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 5049ee5bbad64916b63b932703534668 name: 'SQL Server, Instance {#INST}: Log Send Queue' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Log Send Queue"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: f68b979f14aa4856a483f3289d72219f name: 'SQL Server, Instance {#INST}: Mirrored Write Transactions/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Mirrored Write Transactions/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 02f1f6503d524e73b9f670b899c7cd35 name: 'SQL Server, Instance {#INST}: Recovery Queue' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Recovery Queue"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 89824f37881e4d31a32a0b16db051816 name: 'SQL Server, Instance {#INST}: Redo blocked/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Redo blocked/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: b50ff7d1d6d941749ba62a880ed5f738 name: 'SQL Server, Instance {#INST}: Redo Bytes Remaining' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Redo Bytes Remaining"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 20c310a4afae4971b36d258f3f152dc3 name: 'SQL Server, Instance {#INST}: Redone Bytes/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Redone Bytes/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: 4278e29da49f4434918b53510969b383 name: 'SQL Server, Instance {#INST}: Redones/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Redones/sec"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: f1c85de2c76f4cc393f4064ca58a2bba name: 'SQL Server, Instance {#INST}: Total Log requiring undo' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Total Log requiring undo"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: c636383d2e774a7c88869a946fd1613a name: 'SQL Server, Instance {#INST}: Transaction Delay' key: 'perf_counter["\{#PERFCOUNTERNAME}:Database Replica(_Total)\Transaction Delay"]' tags: - tag: Application value: 'MSSQL REPLICA' - uuid: aa0f3291754b4b0490cd0bad2809770c name: 'SQL Server, Instance {#INST}: Databases(_Total)\Percent Log Used' key: 'perf_counter["\{#PERFCOUNTERNAME}:Databases(_Total)\Percent Log Used"]' tags: - tag: Application value: 'MSSQL DATABASE' - uuid: fb42f913f52a4f9fb55b5ca104e193d5 name: 'SQL Server, Instance {#INST}:General Statistics\User Connections' key: 'perf_counter["\{#PERFCOUNTERNAME}:General Statistics\User Connections"]' tags: - tag: Application value: 'MSSQL STATS' - uuid: 518206a62aaf4bcdb005eb3465138df4 name: 'SQL Server, Instance {#INST}:Locks(_Total)\Lock Timeouts/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Locks(_Total)\Lock Timeouts/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL LOCKS' - uuid: 17e59804ecb64ac7ae43f312ae83ea8b name: 'SQL Server, Instance {#INST}:Locks(_Total)\Number of Deadlocks/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:Locks(_Total)\Number of Deadlocks/sec"]' tags: - tag: Application value: 'MSSQL LOCKS' - uuid: 6809df0c4d4a42d9bc3e26385463fd83 name: 'SQL Server, Instance {#INST}:Memory Manager\Memory Grants Pending' key: 'perf_counter["\{#PERFCOUNTERNAME}:Memory Manager\Memory Grants Pending"]' tags: - tag: Application value: 'MSSQL MEMORY' - uuid: 62e8e9e00aab42408d4ed4a89d126d44 name: 'SQL Server, Instance {#INST}:Memory Manager\Target Server Memory (KB)' key: 'perf_counter["\{#PERFCOUNTERNAME}:Memory Manager\Target Server Memory (KB)"]' units: KB tags: - tag: Application value: 'MSSQL MEMORY' - uuid: 8252d3bbede74b16b79dfd7112331dee name: 'SQL Server, Instance {#INST}:Memory Manager\Total Server Memory (KB)' key: 'perf_counter["\{#PERFCOUNTERNAME}:Memory Manager\Total Server Memory (KB)"]' units: KB tags: - tag: Application value: 'MSSQL MEMORY' - uuid: f9bbb03808eb4ab89b0e34fbb3649e17 name: 'SQL Server, Instance {#INST}:SQL Statistics\Batch Requests/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:SQL Statistics\Batch Requests/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL STATS' - uuid: e13c1f694acf4209b17fcea0baa0f062 name: 'SQL Server, Instance {#INST}:SQL Statistics\SQL Compilations/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:SQL Statistics\SQL Compilations/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL STATS' - uuid: fe42250fdd38497594374c9d54290992 name: 'SQL Server, Instance {#INST}:SQL Statistics\SQL Re-Compilations/sec' key: 'perf_counter["\{#PERFCOUNTERNAME}:SQL Statistics\SQL Re-Compilations/sec"]' value_type: FLOAT tags: - tag: Application value: 'MSSQL STATS' - uuid: 546512d7f2fc4966954eaabd521d72c2 name: 'SQL Server, Instance {#INST}:Memory grant queue waits/Average wait time (ms)' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Average wait time (ms))\Memory grant queue waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 790481f1ea024d1f83e09b53c5b61301 name: 'SQL Server, Instance {#INST}:Network IO waits/Average wait time (ms)' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Average wait time (ms))\Network IO waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 8c766f3b8da24020a5b03623d5ea9c8b name: 'SQL Server, Instance {#INST}:Page IO latch waits/Average wait time (ms)' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Average wait time (ms))\Page IO latch waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: c395b1b4685346e0b4916c7b6efc55a0 name: 'SQL Server, Instance {#INST}:Memory grant queue waits/Cumulative wait time (ms) per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Cumulative wait time (ms) per second)\Memory grant queue waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: d0799db5378e4f6aad6187996b4bb335 name: 'SQL Server, Instance {#INST}:Network IO waits/Cumulative wait time (ms) per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Cumulative wait time (ms) per second)\Network IO waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 0832e7eed6ed4fdcb3a69792d53f3e35 name: 'SQL Server, Instance {#INST}:Page IO latch waits/Cumulative wait time (ms) per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Cumulative wait time (ms) per second)\Page IO latch waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: bb431d90319346a88c660855f4c21425 name: 'SQL Server, Instance {#INST}:Memory grant queue waits/Waits in progress' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Waits in progress)\Memory grant queue waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 6e51273dc3144d5588b81a350d1b6b02 name: 'SQL Server, Instance {#INST}:Network IO waits/Waits in progress' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Waits in progress)\Network IO waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 2ed94f886d6449a090e2d79495499223 name: 'SQL Server, Instance {#INST}:Page IO latch waits/Waits in progress' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Waits in progress)\Page IO latch waits"]' tags: - tag: Application value: 'MSSQL WAITS' - uuid: 0697b2c68080464dbd4844bc000c2ee0 name: 'SQL Server, Instance {#INST}:Memory grant queue waits/Waits started per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Waits started per second)\Memory grant queue waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 8375c8951df34e48b6fa931f911b6340 name: 'SQL Server, Instance {#INST}:Network IO waits/Waits started per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Waits started per second)\Network IO waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: 08c2fd8f53a54c72b7bf0bc48dace1c4 name: 'SQL Server, Instance {#INST}:Page IO latch waits/Waits started per second' key: 'perf_counter["\{#PERFCOUNTERNAME}:Wait Statistics(Waits started per second)\Page IO latch waits"]' units: ms tags: - tag: Application value: 'MSSQL WAITS' - uuid: afcd05a208de47e8af4eace8aae4d7f1 name: 'Services Discovery' key: mssql.service.discovery delay: 1h filter: conditions: - macro: '{#INST}' value: MSSQLSERVER operator: NOT_MATCHES_REGEX formulaid: A item_prototypes: - uuid: d0a3005993c94bbe867e99370a63d8d9 name: 'SQL Server {#INST} Service State - {#INST}' key: 'service_state[MSSQL${#INST}]' delay: 10s value_type: FLOAT valuemap: name: 'Windows service state' tags: - tag: Application value: 'MSSQL STATUS' trigger_prototypes: - uuid: 2479d1fa988b4f2c9949484d8ea177e4 expression: | last(/App MSSQL 2008-2016 WSFC/service_state[MSSQL${#INST}])>0 and last(/App MSSQL 2008-2016 WSFC/service_state[MSSQL${#INST}])<255 name: 'SQL Server {#INST} Service state is not running' priority: HIGH - uuid: 094e642525104cdcb809eed5aa1ad211 name: 'SQL Agent {#INST} Service State - {#INST}' key: 'service_state[SQLAgent${#INST}]' delay: 10s value_type: FLOAT valuemap: name: 'Windows service state' tags: - tag: Application value: 'MSSQL STATUS' trigger_prototypes: - uuid: 4a64d32ffd754a2785efc0b58ffbdcdb expression: | last(/App MSSQL 2008-2016 WSFC/service_state[SQLAgent${#INST}])>0 and last(/App MSSQL 2008-2016 WSFC/service_state[SQLAgent${#INST}])<255 name: 'SQL Agent {#INST} Service state is not running' priority: HIGH tags: - tag: Service value: MSSQL valuemaps: - uuid: d08cc83a03ca4c0bb27be7290a1076a9 name: 'Windows service state' mappings: - value: '0' newvalue: Running - value: '1' newvalue: Paused - value: '2' newvalue: 'Start pending' - value: '3' newvalue: 'Pause pending' - value: '4' newvalue: 'Continue pending' - value: '5' newvalue: 'Stop pending' - value: '6' newvalue: Stopped - value: '7' newvalue: Unknown - value: '255' newvalue: 'No such service'