SQL Server 2000, large transaction log, almost empty, performance issue?
- by Mafu Josh
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?