What events are captured in SQL Transaction Logs?

28 February,2013 by Jack Vamvas

Question: Are all SQL Server events captured in the SQL Server Transaction Logs? According to SQL Server BOL “Every SQL Server  database has a transaction log that records all transactions and the database modifications made by each transaction”

Answer:  The SQL Server events captured in transaction logs follow the definition supplied the SQL Server Books Online

1) The start and end of each transaction - Read How to find sql transactions with large logs  for techniques on finding queries generating large transaction logs

2) Every data modification (insert, update, or delete). This includes changes by system stored procedures or data definition language (DDL) statements to any table, including system tables.

3) Every extent and page allocation or deallocation.

4) Creating or dropping a table or index

5) Rollback operations

6) Transaction SID

 Read More

SQL Server - Preallocate SQL Transaction Logs for large queries – Initial Size

SQL Server – Monitor SQL Transaction Log AutoGrowth for performance issues

SQL Server - Inside the sql transaction logs with fn_dblog and current

SQL Server – Read sql transaction Logs with ::fn_dblog

Author: Jack Vamvas (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on What events are captured in SQL Transaction Logs?

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer