Monitoring Database File Space with Zabbix 30-08-2019, 16:49

[huyenduong444]

Hi guys

Hoping someone can help me. I need to be able to monitor database file space in Zabbix. I have tried out many of the templates for monitoring SQL server and they don't seem to do what I need them to do. Essentially, I need to know when a database file or log file (.mdf or .ldf) for a particular databases is within a certain percentage of being full.

Essentially I'm looking to:
1. Discover all data and log files within each database on a server
2. Create two items for each file, space used and maximum space (taking into account autogrowth)
3. Create a trigger for each file that will alert me when a data or log file is within a certain percentage of being full (80% full warning, 90% critical as an example)

Using ODBC is not an option due to the size of our environment and network restrictions.

Thank you!

Huyen

[1berto]

MS Sql server?
I'm not familiar with it... But:
1) If you need to find those files by yourseld how do you would do this? A 'find' command? which?
2) How to you can (by yourself) get the maximum space? There is command ? Or it's a query inside the console?
3) Maybe you can create a autodiscovery, item and trigger prototypes, but i myself had never done it
4) how do you know if a file is 'being full' ? Just reading the file (like a dir command?)
5) Could you install the zabbix agent on the server?