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
Securing SQL Server: DBAs Defending the Database
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for …
book
Microsoft SQL Server 2012 Internals
Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL …
book
Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals
Access detailed content and examples on Azure SQL, a set of cloud services that allows for …
book
SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory
Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server …