TroubleShooting Fast growing transactional logs – Part1

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

http://technet.microsoft.com/en-us/sysinternals/bb897439

download unix for win32 from below site

http://downloads.sourceforge.net/unxutils/UnxUtils.zip?modtime=1172730504&big_mirror=0

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.

http://www.microsoft.com/download/en/details.aspx?id=11461

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..:)

Reference:-

http://blogs.msdn.com/b/scottos/archive/2007/07/12/rough-and-tough-guide-to-identifying-patterns-in-ese-transaction-log-files.aspx

Advertisements

6 thoughts on “TroubleShooting Fast growing transactional logs – Part1

  1. 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!

  2. 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

  3. 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 .

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s