Custom Metrics and Queries for Databases for ArcGIS Monitor

RanaDas — Mon, 29 Jan 2024 09:50:27 GMT

Description:

Request: Enable users to add custom metrics or queries for databases, allowing for the creation of custom monitoring parameters.
Example Use Case: For instance, a query such as SELECT tablespace_name, SUM(bytes)/(1024*1024*1024) AS total_free_space_gb
FROM dba_Free_space
GROUP BY tablespace_name;
could be employed to display the available free space in different tablespaces.

Rationale:

Flexibility and Customization: Providing users with the ability to define and monitor custom metrics or queries is crucial for accommodating diverse database monitoring needs. This feature would empower administrators to tailor monitoring to the specific requirements of their databases.
Enhanced Visibility: Custom queries, like the example mentioned, can offer insights into specific database aspects that might be critical for administrators, such as available free space in tablespaces.
Improved Decision-Making: Custom metrics enable users to track and analyze database performance based on parameters that are most relevant to their organization, facilitating informed decision-making.

Benefits:

Tailored Monitoring: Organizations can define metrics that align with their unique database structures and requirements.
Proactive Issue Identification: Administrators can set up custom queries to identify potential issues or trends specific to their databases.
Comprehensive Database Management: This feature enhances the depth and scope of database monitoring, contributing to a more comprehensive and efficient database management solution.

Re: Custom Metrics and Queries for Databases for ArcGIS Monitor - Status changed to: Under Consideration

GeoJen — Mon, 29 Jan 2024 16:06:01 GMT

geospatialmind — Thu, 18 Jul 2024 17:53:02 GMT

Adding custom metrics would be a great feature to take full advantage of ArcGIS Monitor. Hope to see rolling out this feature in next release.

Amarz — Thu, 14 Nov 2024 16:46:34 GMT

Being notified immediately when a critical services go down would be great!