Zabbix on a MS SQL Server backend

[davux]

Hello,

I'm thinking of using Zabbix to monitor a set of virtual machines (running Linux or Windows) hosted on Azure. Zabbix would itself be one of those VMs. However, instead of using a local MySQL installation, I would like to use SQL Azure as a service.

The SQL Azure service, obviously, uses MS SQL Server. So my question is: as an additional backend to MySQL, PostgreSQL, IBM DB2, etc., has anyone ever tried to port Zabbix on MS SQL? Do we have any idea how much effort that would represent?

Besides my own interest, I think it would be really great to have that in Zabbix, so that people would have a very simple way to deploy Zabbix monitoring on Azure (and of course on-premises MS SQL). I might be able to help, but first I would like to get a better idea of how much effort that would represent.

I've looked on the internet and also asked on IRC, but couldn't find any answer, so I figured I'd ask here.

[Colttt]

at the moment it is not possible to use MS-SQL server as zabbix backend and i dont find a festure request for this.

BUT did we really need that? IMHO zabbix supported too many databases (mysql/mariasql, sqlite for proxys and postgresql) are enough.. because of this zabbix must every time develop thinks that works an all databases so they dont have scope to increase much performance.

[filipp.sudanov]

Well, you can either develop MSSQL support yourself (and support this for new versions of Zabbix), or pay Zabbix SIA so they will develop this within sponsored developent.
Otherwise it probably would never happen - support for additional database requires development and testing effort and these resources are always limited.