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!
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!
Comment