Hey there,
we tried your new SQL Oracle v2 sensor with a bit success. At the moment we're using the key-value-method to test our tablespaces, but with this method you're forced to set the key for every existing tablespace. Is there any way, that the sensor is looking for the key/value pair automatically to create the channels himself? If not we're needed to recreate the sensor every-time we create a new tablespace.
Best regards,
Sebastian
Article Comments
Hello Stephan,
we're evaluating prtg at this moment and we're looking for a monitoring-solution with better test-methods then our current product. And one of our problems is, that we need a dynamic sensor/test which is able to monitor all tablespaces on a database, without the need to create a test/sensor for every new tablespace. We have databases with tons of tablespaces created and deleted by developers. In this situation it is needed, that the monitoring-system is able to check these tablespaces themself. We have a bit of a solution with creating a sensor with sql-query returning the tablespace with the most usage or an usage over x percent. But this is only a workaround at this moment. It would be better if the sensor were able to dynamically create and delete channels for every result in the dataset.
Best regards,
Sebastian
Oct, 2014 - Permalink
As of right now, the method I mentioned above is the only way to achieve what you want. I'll talk to the developer of the sensor if anything in this direction is planned, but I doubt it (at least in the near future). I'll let you know what he said.
Oct, 2014 - Permalink
That would require dynamic sensor channels which are not possible with the built-in sensors I'm afraid. Sorry! What you could do is to use a factory sensor and centralize the values there, but then you'll need to create a sensor for every table space(s) you have at the time and modify the factory sensor to include the new sql sensor. Would that be an option?
Oct, 2014 - Permalink