Book description
- Know how transaction isolation levels affect locking behavior and concurrency
- Troubleshoot and address blocking issues and deadlocks
- Provide required data consistency while minimizing concurrency issues
- Design efficient transaction strategies that lead to scalable code
- Reduce concurrency problems through good schema design
- Understand concurrency models for In-Memory OLTP and Columnstore Indexes
- Reduce blocking during index maintenance, batch data load, and similar tasks
Table of contents
- Cover
- Front Matter
- 1. Data Storage and Access Methods
- 2. Transaction Management and Concurrency Models
- 3. Lock Types
- 4. Blocking in the System
- 5. Deadlocks
- 6. Optimistic Isolation Levels
- 7. Lock Escalation
- 8. Schema and Low-Priority Locks
- 9. Lock Partitioning
- 10. Application Locks
- 11. Designing Transaction Strategies
- 12. Troubleshooting Concurrency Issues
- 13. In-Memory OLTP Concurrency Model
- 14. Locking in Columnstore Indexes
- Back Matter
Product information
- Title: Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners
- Author(s):
- Release date: October 2018
- Publisher(s): Apress
- ISBN: 9781484239575
You might also like
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Microsoft SQL Server 2012 Bible
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Microsoft SQL Server 2012 Internals
Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL …