[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

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.
0
lali_murray
Asked:
lali_murray
  • 2
  • 2
1 Solution
 
chapmandewCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now