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

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

  • Article

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

2019-09-04 (first published: )

104,952 reads

Blogs

Idera GeekSync: SQL Security Principals and Permissions 101

By

Thanks to Idera and all 239 of you who joined the Idera GeekSync webinar...

Arrays in PowerShell–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Passwords = A Good Thing

By

Those my friends are, in my opinion, one of the single most wonderful things...

Read the latest Blogs

Forums

Record counts from the table

By pdsqsql

Hi, I need to count the different total number of records from the table...

Fixing MLS Python Services to Load the Runtime

By Emmitt Albright

Comments posted to this topic are about the item Fixing MLS Python Services to...

The Real REAL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Real REAL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Real REAL

See possible answers