TRN files
-
I have some TRN backups scheduled hourly. All the trn files have about the same size except at the same hour every day I get huge TRN files. Is there a way to determine how this is caused ? Secondly question, is it possible to analyze the TRN files, what's in them?
Rgds,
T.
-
I had the same problem and it came back to my maintenance plan that did the reorgs and optimize. I broke out this part of the maintenance plan and move it to the weekend. As far as your question on analyzing the tlogs I believe there is some software to look at these. Someone else will have to chime in on this.
Good luck,
CF.
Chad Fleener -
You can use a third party (Log PI, APEXSQL Log, or something like that). Or you can run Profiler and see what happens during that hour.
-
Thank you both for your input!
I know reorgs can be a reason in explosive grow, but didn't know this would also be the case on OptimizeStats jobs. Will have a look into it.
Thanks.
-
Consider also what's happening in the "real" world, i.e., what your database users are doing. If your office tends to have a flurry of activity at a particular time of day, that would explain the large TRN files happening at the same time of day. For another example, if your TRN files get huge on Tuesday, and you get paid on Thursday, you could safely conclude that your Accounting department is running payroll on Tuesday.
That reminds me of a Dilbert cartoon where Dilbert's company wins a contract to develop a new air traffic control system. Amazingly, Wally delivers a quick solution by means of some slick code reuse. But later over lunch the guys talk shop and the other engineers stare aghast at Wally: "You used code from the Accounting program?!"
And Wally says, without missing a beat: "Here's a tip: Don't fly on payday."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply