search

MantasTumenas / Zabbix-template-for-Microsoft-SQL-Server

Zabbix templates for Microsoft SQL Server. Features MS SQL performance counters. MS SQL instance Low Level Discovery. MS SQL database Low Level Discovery. MS SQL agent job Low Level Discovery. MS SQL database mirroring monitoring. MS SQL Always On monitoring. MS SQL Log Shipping monitoring. Supported versions Tested on Microsoft SQL Server 2012, 2014 and 2016. It may work with earlier versions, but some items (with missing performance counters) may be unsupported. For the extensive overview on the performance counters difference between MS SQL 2008 and MS SQL 2012 you can read here (https://blog.dbi-services.com/sql-server-2012-new-perfmon-counters/). Tested on Zabbix 3.4.0. It may work with earlier versions, but some items (for example service.info[service,]) may be unsupported. The template was started on Zabbix 2.4.0 but after each new Zabbix version, objects were modified or new things were added.
GNU General Public License v3.0
50 stars 27 forks source link

Future implementation? #33

Closed killmasta93 closed 4 years ago

killmasta93 commented 4 years ago

Hi there, Thank you for taking the time of this template, Was wondering two things

1) possible to add on the template the top 10 expensive queries? and the Data File I/O the picture is from what i see on SSMS on the activity monitor

image

2) would be it possible to replicate to monitor on ubuntu server running linux mssql 2019?

Thank you

MantasTumenas commented 4 years ago

Hello, "possible to add on the template the top 10 expensive queries?" - no. At least I do not know how to do that. Also there are limitations on how many symbols a zabbix item can hold in a latest data field. 255 symbols if I am not mistaken. So any (expensive) query, usually is longer than 255 symbols. "Data File I/O" - if it can be monitored via windows OS performance counters, you can create by yourself. I will not create it on SQL template, but I have created them on a separate Windows OS template. [image: image.png]

"would be it possible to replicate to monitor on ubuntu server running linux mssql 2019?" It is a highly requested feature, but I postponed it till the Corona storm will pass. At the moment I do not have time or resources to create and test it on the linux platform.

sincerely, Mantas

On Sun, Aug 16, 2020 at 6:26 AM killmasta93 notifications@github.com wrote:

Hi there, Thank you for taking the time of this template, Was wondering two things

  1. possible to add on the template the top 10 expensive queries? and the Data File I/O the picture is from what i see on SSMS on the activity monitor

[image: image] https://user-images.githubusercontent.com/13953629/90325813-069eda00-df46-11ea-9f0e-4a66520e23fb.png

  1. would be it possible to replicate to monitor on ubuntu server running linux mssql 2019?

Thank you

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/33, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALMGUTBQU27OFFRKVPGN7ETSA5GWPANCNFSM4QATJEDQ .

killmasta93 commented 4 years ago

Thanks for the reply, will keep that in mind, as for the mssql 2019 if you need the resources i can create you VM and give you access, thank you again