The Foglight cartridge for Oracle and SQL Server has a user defined query (user defined collection) component that allows users to provide custom SQL statements to retrieve data. With this solution you would be able to run custom queries to gather data in addition to data the Foglight SQL Server cartridge provides without installing an agent on the monitored server.
Use the User-defined Collections view in the Databases Administration dashboard to add user-defined collections to all of the currently selected agents, in order to provide for queries not included in Foglight for Oracle.
After collections are added, this view displays all user-defined collections for all of the agents; for example, if a collection was added to 12 agents during its addition, the view will display 12 rows, showing the collection for each agent.
This view is also used for configuring the sampling frequency for each collection.
The available sampling frequencies are:
- Real-Time - When a user is currently focusing on a screen, the sampling frequency for all of the collections associated with this screen switches to Real-Time.
- Online - When at least one user is connected, the sampling frequency for all of the collections that are not currently running at Real-Time frequency switches to Online.
- Offline - when no user is currently connected to the application
Please refer to the Foglight user guide for more information on configuring and viewing User-Defined Collections in Foglight.