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.pyin/usr/libexec/netdata/python.d/ - Place
sqlserver.confin/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 linesqlserver: 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