null
Loading…
Skip to main content Skip to buy box

Holiday gifts by Fri, Dec 18? Order by Thu, Dec 3. Plan gifts Gifts by Dec 18? Order by Dec 3. Plan

Free shipping on most orders over $95 in the contiguous US

Specialists Mon–Fri, 8:30 am–5 pm PTSpecialists Mon–Fri, 8:30–5 PT866-522-6657

Printed to order
Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database book cover by Thomas LaRock, Enrico van de Laar
Paperback

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

by Thomas LaRock and Enrico van de Laar

From $52.79 / copy at 25+ copies; lower per-copy prices at higher quantities (see Volume pricing) As low as $51.59 at 100+

Total $1,319.75

Paperback · 402 pages Apress · 2023

Format

Paperback
Volume pricing

The more copies, the less each one costs

Applied automatically in your cart. No code needed.

More than a box of books

Turn this order into a program

Groups that order together often pair the copies with something more. We handle the extras so you don't have to.

About the book

Pro SQL Server 2022 Wait Statistics

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know 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. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. 

The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You’ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more.

Clear examples are included to help you gain practical knowledge of why and how specific wait times increase or decrease, how they impact your SQL Server’s performance, and what you can do to improve performance. After reading this book, you won’t want to be without the valuable information that wait statistics provide regarding where you should be spending your limited tuning time to maximize performance and value to your business. 


What You'll Learn

  • 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 


Who This Book Is For

Database administrators who want to identify and resolve performance bottlenecks, those who want to learn more about how the SQL Server engine accesses and uses resources inside SQL Server, and administrators concerned with achieving—and knowing they have achieved—optimal performance



Details

Publisher
Apress
Authors
Thomas LaRock, Enrico van de Laar
Format
Paperback
Published
Jan 12, 2023
ISBN-13
9781484287705
Pages
402
Printing
Printed on demand
Buying for a group

Pro SQL Server 2022 Wait Statistics for groups: pricing

Volume pricing applies automatically in your cart. No codes, no account needed.

CopiesPrice per copyYou save
25 – 49 $52.79 12% off list
50 – 99 $52.19 13% off list
100+ $51.59 14% off list
Ways groups use it

Popular for

1
Book clubs

A copy for every member, on one order.

2
Events and conferences

A book for every attendee, delivered to your venue.

3
Gifts

For clients, staff, members or volunteers.

Where can I buy 100 copies of Pro SQL Server 2022 Wait Statistics?

BookPal sells Pro SQL Server 2022 Wait Statistics in quantity. At 100 copies the price is $51.59 a copy, against a list price of $59.99, and the cart applies the volume tier automatically. Free shipping on most orders over $95 in the contiguous US. A specialist can quote a larger or mixed order.

  • New books only, straight from the publisher
  • Volume prices apply automatically in the cart, with no code needed
  • Order at least 10 business days before you need the books (11 from mid-November through December)

Ask a specialist about a larger or mixed order

What does Pro SQL Server 2022 Wait Statistics cost when I buy for a group?

Volume pricing applies automatically in your cart, with no code needed. Price per copy: 25 to 49 copies, $52.79 (12% off list); 50 to 99 copies, $52.19 (13% off list); 100+ copies, $51.59 (14% off list). Need a different quantity, or a quote to forward for approval? Ask a specialist and we will confirm pricing before you pay.

How fast can I get copies of Pro SQL Server 2022 Wait Statistics?

This title is printed on demand, so it needs production time before it ships. Need them by a specific date? Request a quote and we'll confirm timing before you pay.

Can you ship to several locations or people's homes?

Yes. We ship group orders to one address, to multiple sites, or to individual recipients, in the US and internationally. See fulfillment options.

Can I get a formal quote for approval before ordering?

Yes. Request a quote and we'll send a PDF you can forward for approval.

Do you accept purchase orders and tax-exempt orders?

Yes. We accept purchase orders upon approval, as well as cards, PayPal, ACH, wire transfers and checks. BookPal is a tax-exempt supplier in all 50 states. See purchase orders and sales tax exemption.

What if I find a lower price?

Send us the link. We match prices from other booksellers and distributors on a new copy in the same edition, available to ship in the quantity you need. Clearance sales and pricing errors are the exception, and we'll tell you quickly if that's the case. Start a price match.

Send for approval

Get a yes from your approver

Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database
Email it to my approver

Your approver gets a link to this page with the quantity set and an "Approve and order" button. Nothing is sent until you press send in your email app.

Log In
Review Your Cart
Your cart is empty Your cart is empty Your cart is empty

Menu

Recently Viewed Recently Viewed
Back to top Back to top