Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 11, 2003

Audit SQL Server Database Activity Without the Overhead of Triggers Using Log Navigator

By DatabaseJournal.com Staff

[From SQL-Server-Performance.Com]

To many SQL Server DBAs and developers, the SQL Server transaction log file is a mystery. Sure, we know its used to maintain database integrity, but what's inside it, and is this information useful? The tools included with SQL Server don't really allow you to peak inside the transaction log to see what's there in a readable and useful form.

So if you could take a peek inside the transaction log, what would you find? In fact, you would find a wealth of information, much of it very useful, especially if you want to see, in detail, the DML (UPDATE, INSERT, DELETE) activities that have occurred in your database.

The SQL Server transaction log keeps track of every data modification performed in your database, who performed it, and when. This is a great way to see what is happening inside your database, and also provides you a way to "audit" DML activity without the need to use triggers, which are commonly used to audit transactions in many companies. While triggers are a convenient way to audit SQL Server DML activity, they also invoke a certain amount of overhead, which can hurt SQL Server performance. On the other hand, using the log for auditing eliminates the overhead of tracking DML activity.

The article continues at http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM