Jan Kleinert - Demystifying Database Performance Issues With SQL Commenter and Cloud SQL Insights

Опубликовано: 09 Октябрь 2024
на канале: Percona
374
5

Have you ever tried to troubleshoot a database performance issue in an application that was built using an ORM? ORMs can simplify development of applications that communicate with databases, but since the ORMs are generating the #SQL statements, it can be difficult to determine which application code is resulting in slow queries.

Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel 📺, and turn on the 🔔 to be alerted to new videos about #OpenSource #Databases... and many other things!
https://percona.tv/subscribe

SQL Commenter is an open source library that enables ORMs to augment SQL statements with comments about the code that caused its execution, making it easier to correlate your application code with the SQL statements that were generated by the ORM.

In this session, we will demonstrate how to set up and use SQL Commenter with an application that uses Sequelize.js to diagnose query performance. We'll also touch on the other frameworks and ORMs that sqlcommenter supports as well as how you can view this data in db logs and observability tools, including Cloud SQL Insights.

You can find more information about #OpenSource #Databases and Percona Database Events in these links 👇👇👇

Watch Percona Live 2021 Talks ⏩ https://percona.tv/PerconaLive2021
Percona Services ⏩ https://per.co.na/Q8eykw
Monitor your Database For Free ⏩ https://percona.tv/pmm-yt
Kubernetes Operator for Databases ⏩https://per.co.na/kubernetes-operators

Connect With us on our Social Networks 👇👇👇
Follow Percona on Twitter: https://per.co.na/twitter
Follow Percona on Facebook: https://per.co.na/facebook
Follow Percona on Instagram: https://per.co.na/instagram
Follow Percona on LinkedIn: https://per.co.na/linkedin