Daily Transaction log growth
All, I want to have a script to record no of transaction log growth daily for each storage Group's MDBs. Due to backup will clean the log, I cannot capture no of log file. Anyone have a solution for this ?? thanks
November 3rd, 2011 11:12am

You can use Performance Monitor and log counter MSExchangeIS Database ==> Instances > Log files generated > Information Store/_Total. Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2011 1:03pm

For me it shows 1424449 - it can't be for one day. How do i know for ach day? Good question Keith.Where Technology Meets Talent
November 3rd, 2011 3:10pm

On Thu, 3 Nov 2011 18:59:50 +0000, Viministrator wrote: >For me it shows 1424449 - it can't be for one day. No, that's the TOTAL number of log files, not the number for one day. >How do i know for ach day? Do you see events like this one in your application log at the end of a backup? .. Event Type: Information .. Event Source: ESE .. Event Category: Logging/Recovery .. Event ID: 224 .. Date: 10/7/2011 .. Time: 10:11:24 PM .. User: N/A .. Computer: SRVR005 .. Description: .. MSExchangeIS (592) SG01: Deleting log files .. D:\ExchangeLogFiles\SG01\E0000003E6C.log to .. D:\ExchangeLogFiles\SG01\E0000003F8A.log. While it's not an absolutely accurate number (not all the log files are deleted) you'll get a pretty good accounting of the log files created between full/normal backups by simply subtracting one number from the other. Otherwise, you could run a script prior to the backup. Get the LogFolderPath from get-storagegroup and then: (get-childitem "$logfolderpath\*" -include E*.log -exclude E*tmp.log).count --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2011 6:07pm

Monitor that counter. The day-to-day difference will give you the exact answer you asked for. Rich's way will work fine too if your backup solution writes that.Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
November 4th, 2011 1:07am

Thanks guys,Where Technology Meets Talent
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2011 4:48pm

Hi keith, Any updates on this issue? If anything is unclear, please feel free to let us know. Thanks, Evan Liu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com
November 6th, 2011 10:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics