Welcome to our blog, which is more than just a record of our experiences. It’s a resource.

Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.

VLFs: Virtual Log Files in SQL Server

VLFs: Virtual Log Files in SQL Server

In SQL Server, a Virtual Log File (VLF) is a concept related to the transaction log file. The transaction log records all the transactions and modifications made to the database. VLFs are logical subdivisions within the physical transaction log file. When a SQL Server...

read more
Fixing High VLFs (Virtual Log Files)

Fixing High VLFs (Virtual Log Files)

A colleague of mine recently published a blog post explaining Virtual Log Files (VLFs) and why it is important not to have too few or too many VLFs. As a follow-up, this article discusses how to reduce VLFs when they have gotten too far out of control. The process is...

read more
Is Your ibdata1 File Growing Excessively?

Is Your ibdata1 File Growing Excessively?

The ibdata1 file is a system tablespace file used by the InnoDB storage engine in MySQL and MariaDB databases. It stores metadata and undo logs for InnoDB tables. The file size of ibdata1 can increase over time as more data is added to the database or as existing data...

read more

Follow Us

Need more information? Let’s Talk Today!