Operations | Monitoring | ITSM | DevOps | Cloud

A few weeks ago, we massively improved the performance of the dashboard & website by optimizing some of our SQL queries. In this post, we'll share how we identified the queries that needed work. In the next post, we'll explore how we fixed each of them. We'll cover the basics and gradually work our way up to the more advanced/complex ways of identifying slow queries. In this post, you'll see: Let's go!

Until recently, Grafana Mimir — our open source, horizontally scalable, multi-tenant time series database (TSDB) — has exclusively used Prometheus’ PromQL engine to evaluate queries. While the PromQL engine works great, it sometimes needs a lot of memory to run, specifically in the Mimir querier component. To address this memory consumption issue, we recently introduced Mimir Query Engine (MQE).

Inconsistent SQL formatting is a silent productivity killer. The database will execute it, but for developers, poorly structured queries lead to slower reviews, harder debugging, and errors that slip through unnoticed. Over time, this lack of consistency compounds into costly technical debt. This guide shows how to format SQL code so it remains clear, consistent, and easy to maintain.

Databases handle critical operations for applications, from online banking to e-commerce and streaming services. Any slowdown or failure can directly affect application performance and user experience. Database monitoring tracks performance, detects issues, and helps prevent downtime. It also ensures efficient use of resources, maintains security, and supports compliance requirements.

Avoid the pitfalls of cloud database migration with Redgate Flyway. Learn how automation, schema discipline, rollback strategies, and traceability reduce risk and enable fast, compliant cloud deployments, with these insights from John Q. Martin, Technology Partner Manager at Redgate Software. Cloud migrations promise faster releases and more flexible scaling, but a poorly executed database migration will stop you from exploiting them.

"Let us support different relational databases apart from SQLite. Nobody likes to run SQLite in production." This was one of the most requested features from our community. Your requests have been heard, and we've added support for different relational databases, starting with PostgreSQL. If you're self-hosting SigNoz, you no longer need to worry about SQLite's limitations. Let's dive into what we've built and why it matters for your production deployments.

ClickUp integration has become a key driver of operational efficiency for over 3 million teams worldwide. By connecting the ClickUp platform with business applications, organizations simplify operations, eliminate manual handoffs, and give leaders the visibility needed to act with confidence. But achieving these outcomes requires a stable integration approach because not all methods offer the same flexibility or access.

MariaDB has become a preferred backend for many enterprises, thanks to features like Galera clustering, JSON functions, and ColumnStore for analytics. But to extract value from MariaDB, organizations need reliable integration with BI tools, ETL pipelines, and custom apps, and this is where MariaDB ODBC drivers come in. These drivers bridge the gap between your database and external systems. But not all of them are production-ready.

Snowflake is the backbone of modern enterprise data architecture, powering over 10,600 organizations—including 800+ Fortune Global 2000 leaders. But thriving in this ecosystem takes more than just the platform. It requires a data architecture that can handle real-world complexity—and that’s where Snowflake connectors come in.