What’s New in Transaction Management
Nothing has really changed in SQL Server 2012 regarding managing transactions within your Transact-SQL code. However, related to internal transaction logging and recovery, SQL Server 2012 introduces the concept of indirect checkpoints. Indirect checkpoints provide a database-level alternative to automatic checkpoints. In the event of a system crash, indirect checkpoints can provide a faster, more predictable recovery time for a specific database than automatic checkpoints. Indirect checkpoints are covered in more detail in the “Transaction Logging and the Recovery Process” section of this chapter.
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
