QTY/Space of Transaction Logs High
On one of my databases, I've noticed that the QTY and space used for transaction logs is high (8GB to 14Gb per day). Does anyone have any PowerShell script suggestions to determine the cause of the transaction log activity? Or other tools? I used the message tracking tool, and it just doesn't help me out. Thanks Ron
January 19th, 2011 2:13pm

Perhaps this will help you http://blogs.msdn.com/b/scottos/archive/2007/07/12/rough-and-tough-guide-to-identifying-patterns-in-ese-transaction-log-files.aspx?PageIndex=2#commentsTroy Werelius www.Lucid8.com
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2011 3:25pm

Also there was an issue awhile back with iPhones causing logs to build rapidly so that might be another source to consider but the above will help you figure out where all the logs are coming from and then you can take action from thereTroy Werelius www.Lucid8.com
January 19th, 2011 3:30pm

Thank you. I'll take a look at your suggestion. Ron
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2011 4:51pm

The ExMon tool was useful. I was able to pinpoint a useful who was taking over 50% of CPU and had the largest Log byte count. Thanks Ron
January 21st, 2011 5:25pm

Happy to assist and here are a few other articles regarding the iPhones issue http://msexchangeteam.com/archive/2010/06/30/455342.aspx http://social.technet.microsoft.com/Forums/en/exchangesvrgeneral/thread/c413598e-7216-4a21-b621-3b6a7c92079a Troy Werelius www.Lucid8.com
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2011 7:58pm

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

Other recent topics Other recent topics