Operations | Monitoring | ITSM | DevOps | Cloud

June 2021

How to Monitor and Optimize Your Database Performance: A Practical Guide

It’s important to be able to look at the entirety of your application architecture, not just specific aspects of it, and understand how different parts connect. Observability comes first, followed by monitoring. In this post, we’ll dive into the database part of your architecture to show how you can monitor and optimize your database performance.

Introducing SQL Monitor's new estate discovery feature

This year we’ve been expanding SQL Monitor’s capabilities around the theme of Estate Management and we’ve just released a new capability – the discovery of on-premises SQL Servers and instances. We started on this journey with basic instance configuration observability and alerting earlier this year. While gathering feedback and finding ways to improve our new configuration features, we worked on and released an Instance Discovery Tool as a preview feature.

How Database Monitoring Can Boost Your Performance

Anyone who is responsible for database performance knows how demanding and challenging database performance tuning is when managing a database. One of the critical functions of this process – database monitoring – is often overlooked. Database monitoring includes identifying the right SQL for tuning, determining right way to tune and whether SQL is right thing to tune.

Introduction to Code Analysis in the Redgate solutions

How do you ensure best coding practices are being adopted and reinforce this approach in your entire pipeline? In this video we show you how the same best practices are unified in the Code Analysis functionality offered by SQL Prompt, SQL Change Automation and SQL Monitor to ensure your team are making the best possible changes.

A DBA's Habit for Success: CMMI (Part Five)

We’ve reached the final piece of our five-part series, and while I’m sad to end it, I hope you or your DBA teams have learned enough to move forward with the Information Management Maturity Model (IMMM). Although there are five steps to this model, several DBAs stop at the fourth. It’s common for large organizations to give this step to management and higher-ups, rather than DBA teams.

SolarWinds SQL Sentry Overview

SolarWinds SQL Sentry is designed to help you quickly identify and address Microsoft SQL Server and Azure SQL database performance problems that could delay, or even halt, data delivery. Find out how SQL Sentry can help you troubleshoot bottlenecks and optimize database performance. SolarWinds® SQL Sentry is a powerful database performance monitoring solution designed to help you find and fix database performance problems—and prevent future challenges—that could delay data delivery or even bring business data systems to a halt.

How to Install SolarWinds SQL Sentry

This video shows you how to successfully install SolarWinds SQL Sentry. SolarWinds® SQL Sentry is a powerful database performance monitoring solution designed to help you find and fix database performance problems—and prevent future challenges—that could delay data delivery or even bring business data systems to a halt.

Using the Redis Command-Line Correctly

Redis is an open-source in-memory data store. You can use Redis as a database, message broker, or cache. It also supports Lua script evaluation so you can build automation scripts or custom operations on top of your key-value Redis store. Typically, developers use language-specific client libraries when building apps with Redis. These clients abstract Redis’ command-line interface (CLI), making it easier to work with but more work to set up.

Fixing It Yourself: Troubleshooting Failing Masking Sets

Data Masker for SQL Server is an incredibly powerful solution for de-identifying any sensitive PII that exists within your SQL Server Databases, but with great power, comes great configuration & customizability (and responsibility, of course). Join Chris, a Redgate Solution Engineer as they walk you through some of the common issues people can face when running masking sets, and how to easily start troubleshooting any failed runs yourself.

Document Oracle, MySQL, and PostgreSQL Databases With Database Mapper

We’re excited to announce SentryOne Document is now called SolarWinds® Database Mapper! The recently released Database Mapper 2021.8 enables you to document three additional database environments: Oracle, MySQL, and PostgreSQL. This makes Database Mapper a great tool to use in conjunction with SolarWinds Database Performance Analyzer and SolarWinds Database Performance Monitor database management solutions.

Why standardizing migrations across multiple database types with Flyway adds up for Desjardins

A new case study shows how Desjardins uses Flyway Teams to standardize the way migration scripts are created and versioned across its multi-database estate, which includes Oracle, SQL Server and PostgreSQL. With assets of over $350 billion and seven million members and clients, Desjardins is the leading financial cooperative in North America.

There's More Than One Way to Monitor Database Performance - SolarWinds Lab Episode #96

In this episode of SolarWinds Lab™, Head Geeks™ Kevin Kline and Thomas LaRock will show you the basics of database monitoring using free features within Microsoft® SQL Server® like Extended Events and SQL Agent Monitoring. Then they'll show you how to extend and amplify your database performance monitoring effectiveness with SolarWinds products Server & Application Monitor, Database Performance Analyzer, SQL Sentry, Database Performance Monitor, and Database Insights for SQL Server.

Gremlin ALFI Demo - AWS RDS Unavailable - Chaos Engineering

In this demo, we'll share how you can use ALFI (Application Level Failure Injection) to make AWS RDS unavailable. This enables you to learn how your application handles different failure modes. We'll be using the ALFI Latency attack to perform this Chaos Engineering experiment.

Why DevOps isn't a level playing field for financial services and insurance

Redgate recently published the 2021 State of Database DevOps report which, for the last five years, has followed the rise in DevOps and the challenges organizations face when adopting it for both application and database development. Based on a survey of thousands of IT professionals from around the world, it also provides the opportunity to dive a little deeper into how those challenges vary sector by sector.

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.