Hello,
since few days I'm struggling with mechanism which monitors datafile usage - via ODBC (without creating anything localy on host.. everyting has to be done from Zabbix Server - query etc.).
So far I invented 3 items which gives me results like:
Item 1: check if datafile is autogrowth or not
Item 2: get free space of drive where is datafile, get datafile growth size and divide both values
Item 3: check whole specified database usage in %
Triger:
If Item1 reports that datafile is autogrowing then check if Item2 gives value less than X or if Item1 reports that datafile is fixed size then check if Item3 is below < Y.
Everything so far went well... but there I met with a biggest problem.
How to make Zabbix to discover all datafiles for specified database and then force it to run that mechanism for each one?
It should be somethnig like: get all datafile names, check Item1,2,3 for datafile1, datafile2 .... datafileX.
Everything should have to be done to be implemented in Template for all MSSQL servers - with the smallest interference into hosts.
Above 3 items works just when I declarete manualy one datafile.
since few days I'm struggling with mechanism which monitors datafile usage - via ODBC (without creating anything localy on host.. everyting has to be done from Zabbix Server - query etc.).
So far I invented 3 items which gives me results like:
Item 1: check if datafile is autogrowth or not
Item 2: get free space of drive where is datafile, get datafile growth size and divide both values
Item 3: check whole specified database usage in %
Triger:
If Item1 reports that datafile is autogrowing then check if Item2 gives value less than X or if Item1 reports that datafile is fixed size then check if Item3 is below < Y.
Everything so far went well... but there I met with a biggest problem.
How to make Zabbix to discover all datafiles for specified database and then force it to run that mechanism for each one?
It should be somethnig like: get all datafile names, check Item1,2,3 for datafile1, datafile2 .... datafileX.
Everything should have to be done to be implemented in Template for all MSSQL servers - with the smallest interference into hosts.
Above 3 items works just when I declarete manualy one datafile.
Comment