Dynatrace managed offers integrations to allow leverage RDS Performance insight Data

[WenG]

Please advise if 

1) the Dynatrace managed offers integrations to allow leverage AWS RDS Performance insight Data, to gain deeper insights into the database performance.  

2) the Dynatrace managed can setup  "Monitoring on Aurora Postgres performance via the EF2.0 extension framework." 

•     monitoring top queries
•     fetching Execution plan details on PostgreSql

[Peter_Youssef]

Hello @WenG 

For PostgreSQL you can proceed with the available OOB extensions offered by Dynatrace:

• PostgreSql
• https://www.dynatrace.com/hub/detail/database-overview/?query=PostgreSql&filter=all

Hoping it helps.

BR, 

Peter 

[WenG]

Thanks For the follow-up.

• Yes, Dynatrace integrate with AWS Performance insight on deeper insights on db performance monitoring is what we are looking for.
• We have Dynatrace Managed version 1.310.83, can you please advise if something we can implement for adding monitoring top queries and fatching Execution plan for PostgreSql ? 

Limitations

Execution plan details:

• Only available to SaaS users with DB App installed
• Execution plan can only be fetched from the database where dynatrace.dynatrace_execution_plan function has been created.

Regards,

Wen 

[Peter_Youssef]

Hello @WenG 

Thanks for your response.

Kindly find the below helpful resources:

• Postgres statements are being detected and monitored from the application server side when the application services call the target Postgre SQL DBs.
• https://docs.dynatrace.com/docs/ingest-from/extensions20/data-sources/sql/postgresql-monitoring
• https://www.dynatrace.com/hub/detail/custom-database-extension/?_gl=1*1ttu2jh*_ga*MTQ2Mjk1NTQ0LjE3Mj...

also ensure the OA related feature is enabled and required action is applied accurately

BR,

Thanks.