SAP Knowledge Base Article - Preview

3433960 - A few database deadlocks for self-analyze

Symptom

  • Dynatrace is missing database monitoring metrics like Deadlocks, DTU consumption, etc.
  • Can we use a system health extended events session or SQL Server Profiler to capture deadlock graphs?
  • Can we use  Azure Monitor to track performance metrics and create alerts for Azure Database '?
  • Can we have access to ' Query Performance Insight' or  'Azure SQL Analytics'?
  • Can we create a thread dump causing deadlocks on the database?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

SAP Commerce Cloud 2205+

Product

SAP Commerce Cloud 2205

Keywords

dynatrace Azure monitoring, dead locks, deadlocks self analysis, dtu limit, database connection, thread , KBA , CEC-SCC-PLA-PL , Platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.