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
49 stars 27 forks source link

Database Items and DB metrics are not getting in Zabbix Dashboard #29

Closed harikrishnaroy closed 2 years ago

harikrishnaroy commented 4 years ago

Hi MantasTumenas,

I have imported the template i am able to see all the metrics of the SQL server but not the SQL database. What needs to be done to get the metrics of the databases in SQL server . Help will be much appreciated.

MantasTumenas commented 4 years ago

First idea - check if you have assigned sysadmin rights to zabbix agent service account.

On Mon, 6 Apr 2020, 14:06 harikrishnaroy, notifications@github.com wrote:

Hi MantasTumenas,

I have imported the template i am able to see all the metrics of the SQL server but not the SQL database. What needs to be done to get the metrics of the databases in SQL server . Help will be much appreciated.

— 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/29, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALMGUTA6GCTUDXS2JD4VMBLRLGZSPANCNFSM4MCFVFLQ .

harikrishnaroy commented 4 years ago

@MantasTumenas Is it mandatory to provide sysadmin rights to zabbix agent service account ?

MantasTumenas commented 4 years ago

No, it is not mandatory. In the manual I wrote to which tables zabbix agent must have read rights. And under which circumstances sysadmin rights is a must. Have you tried that?

On Tue, 7 Apr 2020, 13:28 harikrishnaroy, notifications@github.com wrote:

@MantasTumenas https://github.com/MantasTumenas Is it mandatory to provide sysadmin rights to zabbix agent service account ?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/29#issuecomment-610307908, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALMGUTFMSHCGAHU66AGTSPDRLL55NANCNFSM4MCFVFLQ .

harikrishnaroy commented 4 years ago

@MantasTumenas if we run the zabbix agent with local system will it work ? as we are facing this issue and unable to figure it out. Help very much appreciated.

MantasTumenas commented 4 years ago

Yes, it should work Mantas

On Tue, Apr 7, 2020 at 1:34 PM harikrishnaroy notifications@github.com wrote:

@MantasTumenas https://github.com/MantasTumenas if we run the zabbix agent with local system will it work ? as we are facing this issue and unable to figure it out. Help very must appreciated.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/29#issuecomment-610310690, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALMGUTGZSJ2XLSR6VEGLGSTRLL6VBANCNFSM4MCFVFLQ .

harikrishnaroy commented 4 years ago

Through we run with service account we are not getting any metrics of Sql Server Database. ld you please help us to get that.Help very much appreciated.

MantasTumenas commented 4 years ago

Ok, contact me via gmail. send skype invite or smthg, so I can connect to that server and check

On Tue, Apr 7, 2020 at 1:50 PM harikrishnaroy notifications@github.com wrote:

Through we run with service account we are not getting any metrics of Sql Server Database. ld you please help us to get that.Help very much appreciated.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/29#issuecomment-610317108, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALMGUTCLXLF2SZOPZAIAPYLRLMANPANCNFSM4MCFVFLQ .

MantasTumenas commented 4 years ago

Or send error logs

MantasTumenas commented 2 years ago

Closed due to no response from reporter.