netdata-sqlserver

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

Requirements

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.

Installation

• 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

Screenshots

TODO

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

Troubleshoot

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

Credits

Based on netdata postgres plugin by: facetoe,dangtranhoang

Uses pymssql library