Query
Features
Ability to create Query monitoring component in Germain UX
Configure
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
