Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro SQL Server Wait Statistics

  • Book
  • © 2015

Overview

Authors:
  1. Enrico Laar
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Pro Server Wait Statistics provides deep understanding of SQL Server wait statistics and how to increase SQL Server performance by lowering wait times.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xxv
    Download chapter PDF

  2. Foundations of Wait Statistics Analysis

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Wait Statistics Internals

      • Enrico van de Laar
      Pages 3-20

    3. Querying SQL Server Wait Statistics

      • Enrico van de Laar
      Pages 21-45

    4. Building a Solid Baseline

      • Enrico van de Laar
      Pages 47-67

  3. Wait Types

    1. Front Matter

      Pages 69-69
      Download chapter PDF

    2. CPU-Related Wait Types

      • Enrico van de Laar
      Pages 71-96

    3. IO-Related Wait Types

      • Enrico van de Laar
      Pages 97-134

    4. Backup-Related Wait Types

      • Enrico van de Laar
      Pages 135-144

    5. Lock-Related Wait Types

      • Enrico van de Laar
      Pages 145-170

    6. Latch-Related Wait Types

      • Enrico van de Laar
      Pages 171-205

    7. High-Availability and Disaster-Recovery Wait Types

      • Enrico van de Laar
      Pages 207-225

    8. Preemptive Wait Types

      • Enrico van de Laar
      Pages 227-246

    9. Background and Miscellaneous Wait Types

      • Enrico van de Laar
      Pages 247-267

    10. In-Memory OLTP–Related Wait Types

      • Enrico van de Laar
      Pages 269-283

    11. Example SQL Server Machine Configurations

      • Enrico van de Laar
      Pages 285-288

    12. Spinlocks

      • Enrico van de Laar
      Pages 289-292

    13. Latch Classes

      • Enrico van de Laar
      Pages 293-300

  4. Back Matter

    Pages 301-308
    Download chapter PDF
Back to top

About this book

Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding on how wait statistics are generated and what they can mean for your SQL Server’s performance.

Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statistics helps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server’s performance.

About the author

Enrico van de Laar is a SQL Server professional who specializes in performance tuning and analysis. Enrico is a Microsoft MVP for SQL Server, and a speaker at various SQL Server events around the world. He works for an IT company which focuses on the Dutch healthcare sector, from where he manages, troubleshoots, and optimizes the databases of some of the largest hospitals in The Netherlands.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation