HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

how to interpret log files with high transactions

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
interpretlogwithhighfileshowtransactions

Problem

I'm having this issues with too many logs files being generated. Over 60gb in the last 24 hours. It's not a massively high transactional website. What is the best way to read the log files and work out a likely cause. I'm using SQL Server 2008

Solution

Usually, these questions arise from a misunderstanding of what the log file does. Usually, a larger than expected log is caused by a database in full recovery where log backups aren't being taken.

If you are taking log backups or your database is in simple recovery, there is probably a very large or long running transaction that has required 60GB of log space. KB317375 is a good starting point for understanding why unexpected log growth may occur and includes steps for identifying transactions that could be the cause.

Context

StackExchange Database Administrators Q#4581, answer score: 3

Revisions (0)

No revisions yet.