HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Reading SQL Server 2008 transaction logs

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
reading2008logssqltransactionserver

Problem

I have a requirement for tracking some usage on a table that will be getting retired in the next year and feel that I could get the pertinent data (stored procedures and in-line sql being used against it) from the transaction logs. I've see some expensive purchased options out there for reading the logs but I was wondering if anybody knew of any opensource solutions or some sample code of how to parse these logs?

Solution

Logs are proprietary and those solutions are expensive because it is not simple and the average person does not know how to do it. Since you're using SQL Server 2008, have you considered some other more accessible options, such as:

  • SQL Audit



  • Server-side trace



  • Change Tracking



  • Change Data Capture



  • Taking snapshots of the DMV sys.dm_db_index_usage_stats



  • Forcing access through a stored procedure and employing custom logging



I wrote about some of these here (before 2008 was released):

  • https://sqlblog.org/2008/05/06/when-was-my-database-table-last-accessed

Context

StackExchange Database Administrators Q#19525, answer score: 9

Revisions (0)

No revisions yet.