T-Log

SQL Server Transaction Log Fragmentation: a Primer

  • Article

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.

2012-11-23 (first published: )

7,126 reads

Blogs

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

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

Read the latest Blogs

Forums

Simple query question

By Mysterio

I'm new to SQL and I'm struggling to return a result set which I...

Filtering an R Dataframe

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Filtering an R Dataframe

Seeing the World Differently with a Coach

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Seeing the World Differently with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers