LiteSpeed for SQL Server 8.9 - User Guide

Log Reader - View Transactions

The Transactions page in the Log Reader window lists all the transactions recorded in the loaded log files. You can drill down on any transaction to view information about the individual log records that were generated for the operations that occurred during that transaction. You can use this information to determine what exactly happened during the transaction.

To view transactions recorded in the log

1. Run the Read Log Wizard. For more information, see Read Transaction Logs.

2. Select the Transactions page in the Log Reader window. Log Reader displays the following information about the log entries on this page:

   • Transaction ID
   • Transaction name
   • Transaction type
   • Transaction start timestamp
   • The number of DML/DDL operations in the transaction
   • Transaction end timestamp
   • Transaction end state

3. Navigate through and organize the log record entries to help you locate the information you need to review. Use any of these methods:

   • Navigate through the log entries using the navigation bar at the bottom of the list.
   • Sort the list in ascending order by a specific column by clicking the column heading. Click the column heading again to reverse the sort order.
   • Group like entries in the list. See Group Entries for more information.
   • Filter entries. For more information, see Filter Entries.
   • Find entries. See Find Entries for more information.

4. Select a specific entry to view additional information:

   Tab	Description
   DML/DDL	Function or operation for which the record was generated, the database object affected by the function, and the column type, and the parent table for operations with dependencies.
   User Info	Information about the user and application that made the change. Note: The Log Reader can collect NT User, SQL Login, User Host, and Application information for transactions started only when it is connected to the server.

Related Topics

Analyze Transaction Logs

Read Transaction Logs