I am working with one of the biggest Messaging setup & facing issues where transactional log drives starts to gets fill up very fast. This troublshooting comes with a bit of experience, it involves reading of transactional logs, montoring using Exmon & a guess work sometimes 🙂
Reading transactional logs is not a easy task therefore I have researched a way from Internet which can help you in doing so.
So, lets start….
There are two ways for reading trasactional logs
download strings from below site
download unix for win32 from below site
Extract everything above in c:\unix
Create a folder c:\txnlogs (this is the folder in which you have to copy the txn logs that you want to analyse)
Create a folder C:\output for results.
use the below command for the results
strings -q -n 16 C:\TXNLOGS\*.log | cut -f3 -d: | sort | uniq -c | sort | tee c:\output\log-output.wri
After running this command you will get counts of the data that is repeating.
Now you have to use exmon to match the repeating entry with the entry that is consuming more bytes/CPU.
Match this entry with the database /txn log drive that is having issues.(if user is present in that database then probably that user is culprit for generating lot of txnlogs )
Now get the user active sync device reconfigured on all mobile devices , do CAS reset for the CAS on which user session is there. If there is anything stuck in user outbox then remove it, if there are calendar entries with no end date then tell the user to put some end dates.
Above seems to be simple process but some times give headace’s for finding the culprit..:)
not working any more-blogs.msdn.com/b/scottos/archive/2007/07/12/rough-and-tough-guide-to-identifying-patterns-in-ese-transaction-log-files.aspx
6 thoughts on “TroubleShooting Fast growing transactional logs – Part1”
Respecting the time and effort you put into your site and interesting insight you provide here. It’s awesome to come across a blog in a rare occasion that is not all the same outdated rehashed material. Great job! I’ve bookmarked your site and I’m including your blog URL to my Favorites today. Imagine, I appreciate your site so much that I want to advertise my own site http://www.emt.co.il on yours. I would appreciate you email me at: everythingrainbowhk (AT) gmail.com listing your quarterly ad rates. Looking forward to your email!
Thanks alot.. but right now I am just blogging for sharing the knoweledge I have gathered.
I real equal when you handle this typewrite of block inner your posts. Perhaps could you act this?
I didn’t get you on above ?
TroubleShooting Fast growing transactional logs – Part1 SukhijaVikas's Blog I was suggested this website by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my problem. You are amazing! Thanks! your article about TroubleShooting Fast growing transactional logs – Part1 SukhijaVikas's BlogBest Regards Cindy
Wow, fantastic blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is fantastic, as well as the content!. Thanks For Your article about TroubleShooting Fast growing transactional logs – Part1 SukhijaVikas's Blog .