Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Announcing Our Expanded Database Solutions Portfolio - Designed to Improve the Lives of Database Professionals

Today, SolarWinds announced our expanded database performance management portfolio. With the recent acquisition of SentryOne and launch of Database Insights for SQL Server alongside our award-winning Database Performance Analyzer (DPA) and Database Performance Monitor (DPM) solutions, we intend to become the leader in the database performance management market.

What Happens When I Execute a Query?

To many developers and system administrators—and even to some database administrators—database engines are a black box. They’re complex pieces of software that, in some cases, even have their own operating systems—the database engine manages its own memory, reads and writes to disks, and handles numerous other system functions. In this post, you’ll learn about a specific feature of database engines—query optimization.

The four best features to look out for in SQL Monitor

I’m a Data Architect and I’ve been working with data and databases for years at companies like LA Fitness, Dell and now Kingston Technology in Fountain Valley, California. Over all of that time, I’ve used SQL Monitor. I loved it from the beginning and the latest updates to the global overview dashboard and other features have stepped it up another few notches.

Why Does My Database Need Indexes?

Have you ever deployed a new application that ran fine at first, then slowed to crawl as more and more data was added? Or tried to run a report that took minutes or even hours to come back? Database performance is a frequent bottleneck for many applications, and in this post you’ll learn about a critical aspect of database performance—indexes.

Debugging Azure Functions Locally

Azure Functions are great for running bits of processing on a trigger without having to worry about hosting. Recently, I needed to debug an Azure Function—I needed to hunt down a particularly evasive bug that wasn’t showing up in the unit and integration tests. As it turns out, debugging an Azure Function isn’t as trivial as simply running the debugger in Visual Studio. Instead, it requires some setup to replicate the environment and configuration typically available in Azure.

Crazy Like a Fox: Redis as Your Primary Database

Redis is fast. It’s fast because the data is all in memory. Persistence options are limited. Because of this, many people say, “Redis is for transient data only!” However, sometimes the need for speed and ease of operations can outweigh the durability downsides! In this talk, we look at a real SaaS business using Redis as its (only) datastore. You’ll learn why we decided to go all-in on Redis and the challenges we faced. You’ll learn how we operationalized the setup, handle backups and restores, and how we’ll scale out. Are we making a terrible mistake? You be the judge!

Monitoring and Tuning Open-Source Databases

By continuously running a well-built general-purpose database performance monitoring facility, organizations can gain constant visibility into the availability and responsiveness of their databases and database management systems (DBMSs). When such a tool is equipped with analytics to compare historical metrics against current values, administrators can immediately understand how current values and behaviors stack up against prior averages and typical baselines.