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
Mastering Financial Pattern Recognition
Candlesticks have become a key component of platforms and charting programs for financial trading. With these …
book
The Time Cleanse: A Proven System to Eliminate Wasted Time, Realize Your Full Potential, and Reinvest in What Matters Most
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Tidy First?
Messy code is a nuisance. "Tidying" code, to make it more readable, requires breaking it up …
book
Faster, Fewer, Better Emails
Business communication expert and bestselling author Dianna Booher shares practical wisdom on how to write effective …