Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL

MSDN Fourms
Fort Worth SSUG
Oklahoma City SSDG

Resume

Champion Valley Pens

Log Explorer 2.0 1 2 3 4 5 6 7 8 9 10 11 12 13

Most transaction logs are too large to simply browse.  It also wastes quite a bit of time since you are generally only interested in a subset of the transactions.  The Filtering capabilities in Log Explorer are a significant advance from version 1.0.  The first tab is a welcome change from version 1.0.  This allows you to narrow the set of log records to a specific time range.  By default you get the entire log, but you can now specify any portion of the log to look at.

Recycled data is a very interesting concept within your transaction log that most people don't realize is there.  It is very similar to the way deleting a file works on an operating system.  When you delete a file, you don't physically remove all traces of that file from your file system.  You simply remove a bit in the header of the file that tells the OS it is a valid file.  The data still exists on your disk drive until something overwrites it.  The same concept occurs internal to the transaction log.  When you issue a transaction log backup, the committed transactions are "removed" from the transaction log.  This is NOT a physical removal of that data.  There is simply an update to a bitmap that tells SQL Server which entries in the transaction log are still valid.  When you are reading the raw transaction log as Log Explorer is doing, you will see this data present in the transaction log.  A transaction log writes in a circular manner.  When it reaches the end of the log, it will begin writing back to the pages at the beginning of the log if there is space available.  If not, it will allocate more space to the log.  The recycled data is that data which has been "removed" due to a transaction log, but has not yet been written over by SQL Server.  I generally do not look at recycled data.

Your transaction log contains entries for every conceivable operation that occurs in SQL Server.  I believe there are 47 different operations that are tracked.  you can filter the entries in your transaction log to isolate only specific operations.  You can also isolate this to user data only which is highly recommended since you shouldn't be playing with data in system tables.  One really nice thing about Log Explorer is the extensive help system that provides a significant amount of training.  If you don't understand what a particular operation code is, you can simply look it up in the help system.

Log Explorer 2.0 1 2 3 4 5 6 7 8 9 10 11 12 13

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.