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).

As technology scales and data volumes accelerate, organizations face a pressing challenge: how can they modernize data infrastructure without putting daily operations at risk? Data historians, specialized databases that capture and store time-stamped machine and sensor data, have long been the foundation for reliability and compliance. However, they were not designed for the openness and advanced analytics that modern workloads demand.

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.