Pro SQL Server 2022 Wait Statistics, 3rd Ed (APress)
Monday, 21 August 2023

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.


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

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.




Accelerating Software Quality

Author: Eran Kinsbruner
Publisher: Perforce
Pages: 357
ISBN: 978-8671126044
Print: B08FKW8B9B
Audience: Devops developers
Rating: 3
Reviewer: Kay Ewbank

With a subtitle of 'machine learning and artificial intelligence in the age of devops', this book certainly sounds as though it fits c [ ... ]

Kill It With Fire

Author: Marianne Bellotti
Publisher: No Starch Press
Pages: 248
ISBN: 978-1718501188
Print: 1718501188
Kindle: B08CTFY4JP
Audience: Developers renovating aging systems
Rating: 4.5
Reviewer: Kay Ewbank

The subtitle of this book is "Manage aging computer systems and future proof modern ones". Thi [ ... ]

More Reviews