sql-server-transaction-log-architecture 
SQL Performance
FEBRUARY 1, 2022
In the first part of this series , I introduced basic terminology around logging, so I recommend you read that before continuing with this post. Everything else I’ll cover in the series requires knowing some of the architecture of the transaction log, so that’s what I’m going to discuss this time. Virtual Log Files.
Scalegrid
MARCH 8, 2024
This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. The restoration capability is primarily dependent on binary log files.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
JULY 19, 2022
Previously I’ve talked about why logging is required and the architecture and circular nature of the log, so now it’s time to look at the real heart of the logging system—the log records themselves. What Are Log Records? The simplest definition of a log record: it describes a single change to a database.
Dynatrace
JULY 7, 2022
Many organizations are taking a microservices approach to IT architecture. However, in some cases, an organization may be better suited to another architecture approach. Therefore, it’s critical to weigh the advantages of microservices against its potential issues, other architecture approaches, and your unique business needs.
Percona
AUGUST 15, 2023
In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.
Dynatrace
JULY 12, 2022
Several team members had to pore through logs, metrics, and other data to identify issues. “We The platform might identify, for example, that a SQL database “leverages [a particular] node when we do our Tlog [transaction log] backups,” he says. “We Previously, Park ‘N Fly had to manually troubleshoot.
SQL Performance
JANUARY 20, 2022
All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Basic Terminology Around Logging.
Expert insights. Personalized for you.
53 
Let's personalize your content