Excessive log growth on a database
I have a database who's transaction logs are growing at a rate 10+ times the rate of any other database of equal size and number of users. The actual database size does not seem to be increasing any more then normal. How do I determine the process or user
generating all these logs?Tim
February 7th, 2011 3:48pm
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#comments
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 there. here are a few 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-3b6a7c92079aTroy Werelius
www.Lucid8.com
Free Windows Admin Tool Kit Click here and download it now
February 7th, 2011 5:22pm
Hi Tim,
Any updates?
Which version of Exchange server do you run? If you are running Exchange 2010, please try this script:
Manage Database Log Growth by Using the Troubleshoot-DatabaseSpace.ps1 Script in the Shell
http://technet.microsoft.com/en-us/library/ff477617.aspx
And similar post:
Rapid Database / Transaction Log Growth - 2003
http://social.technet.microsoft.com/Forums/en-US/exchangesvradmin/thread/fc20b6b9-422c-4b21-add0-84c73c778c41
Frank Wang
TechNet Subscriber Support
in forum
If you have any feedback on our support, please contact
tngfb@microsoft.com Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
February 9th, 2011 2:49am
Used ExMon to find the offending user. Turned out to be an iPhone 4 users. Disabled ActiveSync and the problem went away.Tim
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2011 12:32pm
Excellent to hear, and thanks for the update Tim.
BTW If you have some time and are interesting in cool third party tool for Exchange check out Lucid8's DigiScope
http://www.lucid8.com/product/digiscope.aspTroy Werelius
www.Lucid8.com
February 9th, 2011 12:44pm
On Wed, 9 Feb 2011 17:23:35 +0000, Tim Chad wrote:
>Used ExMon to find the offending user. Turned out to be an iPhone 4 users. Disabled ActiveSync and the problem went away.
This might need a bit of updating (to add newer versions of the O/S),
but it helpful when Apple released that buggy version 4.0 of their
O/S.
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2011 6:00pm
On Wed, 9 Feb 2011 22:52:09 +0000, Rich Matheisen [MVP] wrote:
>On Wed, 9 Feb 2011 17:23:35 +0000, Tim Chad wrote: >Used ExMon to find the offending user. Turned out to be an iPhone 4 users. Disabled ActiveSync and the problem went away. This might need a bit of updating (to add newer versions of the O/S), but it
helpful when Apple released that buggy version 4.0 of their O/S. --- Rich Matheisen MCSE+I, Exchange MVP
DOH! I forgot the URL!
http://gsexdev.blogspot.com/2010/08/parsing-iis-log-activesync-traffic-for.html
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
February 9th, 2011 6:01pm