In my last post, I showed you how to configure change tracking at the table level and how to get configuration information about change tracking from the database engine. We looked at
sys.change_tracking_tables, and looked at some sample scripts that present the information in a more readable format.
Before moving on to working with change tracking, I’d like to show you a little bit about how SQL Server handles change tracking data under the hood. Let’s take a few minutes to talk about
sys.syscommittab. These aren’t objects that most DBAs interact with on a routine basis, but they’re useful for understanding how change tracking does what it does.
Click through to learn more about these internal tables.