none
Daily Transaction log growth RRS feed

  • Question

  • 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

    Thursday, November 3, 2011 3:01 PM

Answers

  • 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
    Thursday, November 3, 2011 9:56 PM
  • 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."
    Friday, November 4, 2011 4:56 AM
    Moderator

All replies

  • 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."
    Thursday, November 3, 2011 4:52 PM
    Moderator
  • 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
    Thursday, November 3, 2011 6:59 PM
  • 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
    Thursday, November 3, 2011 9:56 PM
  • 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."
    Friday, November 4, 2011 4:56 AM
    Moderator
  • Thanks guys,
    Where Technology Meets Talent
    Friday, November 4, 2011 8:32 PM
  • 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  

    Monday, November 7, 2011 2:54 AM
    Moderator