SQL Performance

APRIL 5, 2022

In the second part of this series, I described the structural hierarchy of the transaction log. As this post is chiefly concerned with the Virtual Log Files (VLFs) I described, I recommend you read the second part before continuing. When all is well, the transaction log will endlessly loop, reusing the existing VLFs.

Servers 55

Servers Database Virtualization Processing 55

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.

Architecture 53

Architecture Servers Virtualization Database 53

SQL Shack

MARCH 21, 2019

In the previous article of this series on the SQL Server transaction log, we discuss the SQL Server database recovery models, Full, Simple and Bulk-Logged, and the how the recovery model option of the database affects the way the SQL Server Engine works with the transaction logs.

Servers 53

Servers Availability Database Engineering 53

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. And none of these FlushCache messages were ever paired with the 15 second I/O warnings in the error log. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions.

C++ 58

C++ Database Servers Storage 58

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This White Paper is for informational purposes only.

Servers 40

Servers Cache Media Hardware 40

Percona

MAY 15, 2023

Also, in the case of multi-Primary, the writes will be distributed by transaction. If I have a node that manages only the items, another one the orders, and another one the payments, I will need to have my solution able to deal with distributed transactions, each of which needs to certify and verify other nodes’ data.

Traffic 121

Traffic Scalability Database Servers 121