netdata python plugin for sqlserver statistics

SQL Server is available on linux and netdata is the best monitoring tool, therefore this plugin.

Everything is work in progress.

Currently collects performance counter data from sys.dm_os_performance_counters

pymssql must be present on the system. Get it with something like pip install pymssql or apt install python3-pymssql

SQL Server user for netdata. Granted view server state permission.

systemd unit file should be altered for plugin to work on boot. Append mssql-server.service to After= line.

• Place sqlserver.chart.py in /usr/libexec/netdata/python.d/
• Place sqlserver.conf in /etc/netdata/python.d/
• Edit /etc/netdata/python.d/sqlserver.conf, provide username, password, database names to be monitored.
• Edit config using /etc/netdata/edit-config python.d.conf, add line sqlserver: yes
• Restart netdata

• define missing charts (suggestions are welcome)
• possibly organize charts to provide most meaningful results
• implement lock/wait type data collection
• screenshots
• documentation

Something meaningful can be acquired using sudo -u netdata /usr/libexec/netdata/plugins.d/python.d.plugin sqlserver debug

Based on netdata postgres plugin by: facetoe,dangtranhoang

Uses pymssql library