This practical guide, subtitled "A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database" shows how to analyze and troubleshoot SQL Server performance using wait statistics. Thomas LaRock and Enrico van de Laar look at how to identify precisely why queries are running slowly, and how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first.

<ASIN:1484287703>

This edition is updated to cover analysis of wait statistics current with SQL Server 2022. The book goes beyond the most common wait types into the more complex and performance-threatening wait types. It also covers per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve.

Author: Thomas LaRock and Enrico van de Laar
Publisher: APress
Date: January 2023
Pages: 424
ISBN: 978-1484287705
Print: 1484287703
Kindle: B0BS3BHYXB
Audience: SQL Server developers
Level: Intermediate
Category: Database

Topics include:

• Understand how the SQL Server engine processes requests
• Identify resource bottlenecks in a running SQL Server instance
• Locate wait statistics information inside DMVs and Query Store
• Analyze the root cause of sub-optimal performance
• Diagnose I/O contention and locking contention
• Benchmark SQL Server performance
• Improve database performance by lowering overall wait time

For recommendations of SQL Server books see Pick Of The Shelf - SQL Server in our Programmer's Bookshelf section.

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.