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

data not coming in? #36

Closed killmasta93 closed 3 years ago

killmasta93 commented 3 years ago

Hi, Currently we have MSSQL 2016 standard, installed the zabbix agent then the powershell scripts. After that i put the role sysadmin to NT i only get alert for the backup but i dont see the information of mssql nor the agents?

image image image image

Thank you

MantasTumenas commented 3 years ago

By the looks of Your pictures, I guess the problem is server language settings. One user faced similar problem "The problem was that the server i was trying to monitor wasn't in English, so every key of the active template didn't exists, i've translated everything with its proper keys and then it worked". When You go to Performance Monitor and select counters - do You see them in English?

killmasta93 commented 3 years ago

thanks for the reply but whats odd is that i have another server also in Spanish and the info seems to be coming in also not sure if this the location of the counters

image

Thank you

MantasTumenas commented 3 years ago

The location of the counters can be checked here https://docs.microsoft.com/en-us/windows-server/remote/remote-desktop-services/rds-rdsh-performance-counters What language do you see here?

killmasta93 commented 3 years ago

Thanks for the reply, it seems to be in spanish image

is it possible to put the MSSQL into English?

MantasTumenas commented 3 years ago

"is it possible to put the MSSQL into English?" - I do not know of such possibilities. Shorter road would be: copy/paste current template and translate items from English to Spanish. Or translate from English to performance counters IDs (numeric value, same for all languages).

killmasta93 commented 3 years ago

so i reinstalled it better now its working again