DatabasesThe Databases app provides a unified view over all elements necessary for unified observability, including services, hosts, instances, and other core elements that can influence database performance, such as tablespaces, or Oracle multi-tenant entities (like container databases, pluggable databases, and others).
This app aims to be the only tool required to monitor and understand the availability and performance impact of all observed databases for all stakeholders involved.
Coming soon
This application is a brief introduction of a planned end-to-end observability and intelligent tracing for databases application. Please share your feedback about the application via a dedicated Dynatrace feedback channel or by raising a product idea.
Query performance tracking may expose sensitive data in reported statements. Consequently, Dynatrace provides an optional mechanism that allows masking of selected attributes. Details are available in Dynatrace Documentation.
The configurations below shows you how to hide data, specifically for the purpose of query performance tracking.
The first option is to create a processing rule under Settings -> Log Monitoring -> Processing by filling Processor definition e.g.
USING(INOUT content) | FIELDS_ADD(content: REPLACE_PATTERN(content, "(\"'\"):p1 (LD):p2 (\"'\"):p3", "${p1}${p2|sha1}${p3}")) .
The same can be achieved by extension modification, which involves additional logProcessingRules section.
logProcessingRules:
- ruleName: TopN statements masking
query: event.group="query_performance"
enabled: true
ProcessorDefinition:
rule: |
USING(INOUT content) | FIELDS_ADD(content: REPLACE_PATTERN(content, "(\"'\"):p1 (LD):p2 (\"'\"):p3", "${p1}${p2|sha1}${p3}"))
RuleTesting:
sampleLog: |
{
"event.group": "query_performance",
"content": "/*dt:ownQuery*/SELECT DECODE(name, 'sessions', value) AS sessions_limit, DECODE(name, 'processes', value) AS processes_limit FROM v$parameter WHERE name IN('sessions', 'processes')"
}
Please adjust the above rule to match your environment, if needed.
Observe, analyze and optimize the usage, health and performance of your database
Improve the health and performance monitoring of your Microsoft SQL Servers.
Expand visibility to improve health and performance monitoring of your Snowflake
Easily understand the health and performance of your SAP HANA databases.
Remotely collect monitoring metrics from your DB2 databases.
Monitor your Postgres performance via our new EF2.0 extension framework.
