Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating