Database

Building extremely deep monitoring as a SaaS product has a drawback: we capture too much data for some customers’ compliance requirements. As a result, some companies have been unable to…

If you keep up with the Go development cycle, then you’ll know Go recently entered its feature-freeze for the Go 1.11 release. One of the changes for this upcoming release…

You have to be careful what you wish for. The signal:noise ratio of finding out which indexes are “unused” is low. This isn’t obvious at first glance, but upon deeper…

Why is selecting the right queries to optimize so important? There are several reasons. Penny-Wise, Pound-Foolish  Look at the forest, not just the trees, and optimize globally, not locally. If…

Logic and objective thinking are hallmarks of any engineering field. IT design and troubleshooting are no exceptions. Computers and networks are systems of logic so we, as humans, have to…

In system design, every technical decision can be seen as a series of trade-offs. If I choose to implement Technology A it will provide a positive outcome in one way,…

Here is an interesting article from my colleague Joe Kim, in which he explores database health and performance. Part of the problem with managing databases is that many people consider…

Numeric optimization is a set of techniques for fitting a function to a dataset by iteratively refining estimates. Numeric optimization is one way to do things like curve-fitting and parametric…

Thus far, we have gone over how to classify our disasters and how to have some of those difficult conversations with our organization regarding Disaster Recovery (DR). We’ve also briefly…

I’m pleased to announce that SolarWinds® Database Performance Monitor (DPM) offers 99th percentile metrics to help understand latency outliers in a query workload. These metrics provide visibility beyond the average…