There are many ways to monitor Microsoft SQL Server, too many to even list them here.…
In my previous blogpost I shared a way to do general purpose monitoring of your SQL Server environment using Zabbix, and a Zabbix template that I have developed. Read about that here: http://sqlservice.se/sv/start/blogg/monitoring-sql-server-for-free.aspx . This time I have created a template to do just a little more in depth monitoring of a single default instance of SQL Server. Since the general background is described in my last post, I will leave that out of this post and just give you the link to the template: https://www.zabbix.org/mw/images/1/15/Zabbix_Template_SQLServer_MultiDatabase_generator.zip
It is obviously not complete, more of a proof of concept, but feel free to add counters, modify and change the template.