Transaction Log

Optimizing Transaction Log Throughput

  • Article

As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.

2014-05-27

3,916 reads

Manual cleanup Change Data Capture for a SQL Server database

  • Article

Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.

2013-09-11

3,682 reads

Blogs

Daily Coping 4 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – June 2020 – DML Triggers

By

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Read the latest Blogs

Forums

Database Extended Properties

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Extended Properties

Date Join Issue

By nymets86

I joined two tables together trying to get a field out of one and...

estimated execution plan

By sizal0234

  I have an SP which is truncating a table and then insert into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers