SQL Server 2000, large transaction log, almost empty, performance issue?

Posted by Mafu Josh on Server Fault See other posts from Server Fault or by Mafu Josh
Published on 2010-05-28T14:27:19Z Indexed on 2010/05/28 14:33 UTC
Read the original article Hit count: 253

For a company that I have been helping troubleshoot their database.

In SQL Server 2000, database is about 120 gig.

Something caused the transaction log to grow MUCH larger than normal to over 100 gig, some hung transaction that didn't commit or roll back for a few days. That has been resolved and it now stays around 1% full or less, due to its hourly transaction log backups.

It IS my understanding that a GROWING transaction log file size can cause performance issues.

But what I am a little paranoid about is the size. Although mainly empty, MIGHT it be having a negative effect on performance? But I haven't found any documentation that suggests this is true.

I did find this link: http://www.bigresource.com/MS_SQL-Large-Transaction-Log-dramatically-Slows-down-processing-any-idea-why--2ahzP5wK.html but in this post I can't tell if their log was full or empty, and there is not any replies to the post in this link.

So I am guessing it is not a problem, anyone know for sure?

© Server Fault or respective owner

Related posts about sql-server

Related posts about Performance