Database

Latest Posts in Database

8 Reasons Why ChatOps Isn’t Working At Your Company

About a year and half ago I published a blog post about ChatOps at VividCortex (if you’re unfamiliar with ChatOps, that original post still serves as a good primer). At…

See the Details with 1-Second Resolution Data

We’ve talked a lot about the high-resolution data we capture, but if you haven’t experienced it yourself, it might be a little abstract. Here, look at the difference between 1-second…

Is That Query Bad?

This post is part of an ongoing series on the best practices for effective and insightful database monitoring. Much of what’s covered in these posts is not intuitive, yet vital…

A Trendline Is a Model

This post is part of an ongoing series on the best practices for effective and insightful database monitoring. Much of what’s covered in these posts is unintuitive, yet vital to understand. Previous…

The Value of Log Structured Merge Trees

Indexes are usually built by way of a data structure; typically, that structure takes the form of a “tree.” Most commonly, the structure of choice is a B-Tree, which is…

Capacity Planning with the Universal Scalability Law

“How much load can this system sustain?” is a common question in capacity planning. The practical purpose is usually something like the following: How soon will the system begin to…

Introducing Query Anomaly Detection

Anomaly detection sure is a hot topic. We’ve written about it ourselves a number of times, and Preetam Jinka and I just co authored a book for O’Reilly called Anomaly…

Nobody Loves Graphite Anymore

Many of our customers use Graphite, and I don’t think anyone would argue with me when I say it’s probably the most commonly used time series database in the DevOps…

Troubleshooting SQL Server, Part 2 : Inside or outside? Error or Not?

In the popular white paper entitled Troubleshooting SQL Server Wait Statistics, I take you through three scenarios in which a wait stats-only approach is insufficient or even harmful to detecting, diagnosing,…

Great Advice on Monitoring Amazon RDS For MySQL From Datadog

Our friends at Datadog just published an insanely great three part series on monitoring Amazon RDS for MySQL using Datadog. You should go read that now.