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