Feature

Ability to create Query monitoring component in Germain UX

Configuration

Create a New Query Monitor Component

1. Log on to Germain Workspace > left menu > System > Component Types

2. Add and select Database Query Monitor Component

3. Provide Name for component

4. Click Next

5. Select Database where the query will be run

6. Select credentials for DB access

7. Provide a name for the query

8. Write SQL query in SQL field, you can validate the query here as well

9. Click Next

10. Select KPI from drop-down list

You may choose to add custom KPI and rules (discussed below)

11. Click Next

12. Provide SLA threshold value

13. Click Finish

Add an additional query to an existing Query Monitor

1. Log on to Germain Workspace > left menu > System > Component Types

2. Add and Query Monitor Component

3. Click on the component to edit it

4. Click the add/plus button under Queries section

5. Select Database and Credentials for the database

6. Click Next

7. Provide a name for the query

8. Write SQL query in SQL field, you can validate the query here as well

9. Click Next


10. Check Custom rule and select KPI

11. Click Finish


12. You can view all the queries for this component here

13. From this page you can enable, disable, delete or reorder the priority of queries

Create KPI for Query Monitor

1. Germain Workspace > left menu > Analytics > KPIs

2. Click add/plus button

3. Provide Name

4. Choose Generic Event or Generic Transaction as Fact Class

5. Provide a unique name for Fact Category(i.e Query: Sample Query)

6. Select Fact-based SLA

7. Click Next

8. Provide Name for SLA

9. Provide threshold value in seconds

10. Choose color (i.e. Red, Orange)

11. Click Next

12. Optional Step. You may choose to add an alert. You can select them from the drop-down list

13. Click Finish

Create your Dashboards

More details

Create your Rules

More details

Component: Engine

Feature Availability: 8.6.0 or later