MSSQL: Find Biggest Transaction size

Hi experts!

I have a transactional backup plan in place on a 2005 MSSQL Server and I would like to know the biggest transaction size that ever happend to have a pretty good idea of the "worst case scenario".  Is this an information we can get? Thanks for the help.
lali_murrayAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
Not really info you can get without some sort of 3rd party tool such as lumigents log explorer...and even then, not sure you could find the "biggest" transaction.  I assume you mean the longest running?

Stuff like this is better suited to capture with a trace, rather than going back and trying to read the logs.
0
 
lali_murrayAuthor Commented:
The longuest running transaction would be nice to have, but I have a MRP job running nightly and it generate quite a bit of transactions. The logs are getting pretty big at this moment and I would like to be able to find out the size of the biggest transaction so I have an idea of how much the log file should grow without being too fragmented
0
 
chapmandewCommented:
log files don't get fragmented like a data files does...they are written sequentially.  

if your log files are getting too large, consider doing more frequent log backups...that will keep the log file smaller.
0
 
lali_murrayAuthor Commented:
Thanks for the fast reply
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.