Our next-gen architecture is built to help you make sense of your ever-growing data. Watch a 4-min demo video!

Back to All Docs

Database Monitoring

Last Updated: May. 22, 2024

Part of Application Performance Monitoring, Coralogix’s Database Monitoring offers comprehensive insights into databases and service-database interactions across your host environment, enabling efficient and rapid troubleshooting of issues as they emerge.

Database Monitoring is now in beta for early adopters.

Getting started

Instrumentation

To get started with Database Monitoring, set up APM. This includes instrumenting your service to generate spans and installing the Otel Collector.

TCO Optimizer

The span kind ‘Client’, which includes the database queries, must be sent to Coralogix’s Medium: Monitoring TCO pipeline.

Semantic conventions for database client calls

Follow these instructions to add connection-level attributes to your spans. The labels below allow us to identify your system’s service-database interactions. All labels are required.

AttributeTypeDescriptionExamples
db.systemstringAn identifier for the database management system (DBMS) product being used.elasticsearch, dynamodb, mysql, postgresql
db.namestringThis attribute is used to report the name of the database being accessed.customers, main, ws-alerts, ops
db.operationstringThe name of the operation being executed, e.g. the MongoDB command name findAndModify or the SQL keywordSelect, Upsert, Update, Bulkdelete
db.statementstringThe database statement being executedSELECT * FROM wuser_table; SET mykey “WuValue”
net.peer.namestringIdentifies the host name or IP address of the peer (remote host) involved in the communicationnet.peer.name="example.com" or net.peer.name="192.0.2.1"

Explore Coralogix Database Monitoring

Through service instrumentation, Coralogix identifies interactions between your services and databases. The Database Catalog presents all identified databases that interact with your instrumented services.

Navigate to APM > Database Catalog in your Coralogix toolbar.

Master your database landscape: A complete overview

The APM Databases tab provides a panoramic snapshot of all databases interacting with instrumented services within your system during a specified time frame.

  • Visualize query times, query failures, and failure rates across all queries, with easy filtering based on span attributes such as db.name or db.user.
  • Dive into database usage patterns using the Databases Grid, which aggregates data by database name.
  • For detailed investigation, filter the Databases Grid by calling service to analyze service operations per specific database. Refine your analysis by filtering data based on any tag or process tag associated with the calling service.

Click on any row in the Databases Grid to investigate a specific DB host.

Deep-dive into database performance metrics

The Databases Overview presents database performance metrics. View a database’s performance over time, interactions with each calling operation, and queries.

  • Visualize database performance metrics to rapidly identify queries and operations grouped by DB tables requiring troubleshooting.
  • Identify slow queries and which queries are consuming the most time.
  • Incorporate service-based filters to observe specific database-service interactions.

Investigate operations

The Database Operations view presents query performance metrics categorized by operation and table, showcasing their evolution over time within the selected time frame.

  • Visualize database performance metrics to quickly pinpoint queries and operations associated with DB tables that may require troubleshooting.
  • Examine individual service call operations in the Operations Grid to identify specific interactions between services and database tables.
  • Filter based on the services initiating calls to the database.

Examine database queries

Deep-dive into database queries by clicking on any operation or widget across the Database Catalog. This will open a detailed side modal showcasing related spans, allowing users to examine specific database queries and their impact.

  • Visualize query time metrics and compare total failed responses against total success per DB operation grouped by DB table. Graphs update automatically to the selected time frame.
  • Investigate queries associated with a chosen operation in the Queries Grid. Columns are sortable and adjustable.
  • Enjoy a detailed view of all call attributes specific to the queried database.
  • Examine specific database queries and their impact within the broader context of Coralogix’s Application Performance Monitoring. You can easily navigate to a span’s Trace ID page, view raw span data, and copy and share links to specific traces for collaborative troubleshooting.

Database retention

If a database has no service interactions for 30 days, the database is removed from the Database Catalog. This practice ensures the Catalog remains current and uncluttered, simplifying user navigation. To adjust the 30-day retention period, utilize our Service Retention gRPC API. Should service interaction resume after a database’s removal, the database will reappear in the Database Catalog.

Additional resources

DocumentationAPM Onboarding Tutorial
Service Retention gRPC API

Support

Need help?

Feel free to contact us via our in-app chat or by emailing support@coralogix.com.

On this page