T-Log

External Article

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

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

what does this error mean?

By water490

I was running a SP and I got this.  This is the first time...

how to properly index?

By water490

I am not sure how to decide on how I should index my tables...

Software Updates, Outages, Processes, and Protocols

By Ryan Booz

Comments posted to this topic are about the item Software Updates, Outages, Processes, and...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers