Loading in 2 Seconds...
Loading in 2 Seconds...
Required Slide. SESSION CODE: DAT318. Auditing, Tracking, and Change Monitoring Technologies in Microsoft SQL Server 2008. Adam Machanic Database Consultant SQLblog. About Me. Independent SQL Server and .NET Consultant Boston, MA. Author SQL Server 2008 Internals
SESSION CODE: DAT318
Independent SQL Server and .NET Consultant
AuthorSQL Server 2008 Internals
Expert SQL Server 2005 Development
Conference and INETA Speaker
Connections, PASS, TechEd, DevTeach, etc.
The SQL Server Blog Spot on the Web
Txn 1 Starts
Txn 2 Ends
Txn 1 Ends
Txn 2 Starts
ALTER DATABASE AdventureWorks
SET CHANGE_TRACKING = ON;
ALTER TABLE HumanResources.Employee
1: Transaction Starts
2: Rows Modified
xact_id used in base and change table
3: Transaction Committed
> [version from the last collection]
… or …
Does [version from the last collection] == 0
Call CHANGETABLE in VERSION mode
Get the initial snapshot
Call CHANGETABLE in CHANGES mode
Get changes since the last collection
Store for the next iteration
Rows Modified, Transaction Committed
Log Reader kicks in, reads the changes from the log
Change information written to table in CDC schema
Advanced tracing infrastructure—new in SQL Server 2008
Designed from the ground up for performance and scalability
Similar scope to SQL Trace, but much bigger surface area
SQL Audit is built on top of XEvent
Track PMs will supply the content for this slide, which will be inserted during the final scrub.DAT Track Scratch 2 Win
Complete an evaluation on CommNet and enter to win!
You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year
© 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.