Skip to content
  • Training
  • Consulting
  • First Responder Kit
  • Blog
    • Popular Topics
    • Well, Actually...
  • Videos
  • Log In
Newsletter

Wait Types – ASYNC_NETWORK_IO (7 minutes)

When this wait type is your biggest bottleneck, your work is done! Well, not really – DBA stands for Default Blame Acceptor, and you’ll still take the blame for this wait, but now you’ll understand why you probably can’t fix it: [wpc_button]

To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.
03. How to Measure and Change Your SQL Server – The Parts Catalog (7 minutes) Wait Types – CXPACKET (54 minutes)

In this class

Fundamentals of Server Tuning with Wait Stats
  • 01. How to Measure and Change Your SQL Server – 3 Metrics to Gather (23 minutes)
  • 02. Measuring Your SQL Server with sp_BlitzFirst and Monitoring Software (24 minutes)
  • 03. How to Measure and Change Your SQL Server – The Parts Catalog (7 minutes)
  • Wait Types – ASYNC_NETWORK_IO (7 minutes)
  • Wait Types – CXPACKET (54 minutes)
  • Wait Types – LCK% – Locking Snapshot RCSI Part 1 (39 minutes)
  • Wait Types – LCK% – Locking Snapshot RCSI Part 2 (29 minutes)
  • Wait Types – PAGEIOLATCH Part 1 – Slow Reads from Storage (7 minutes)
  • Wait Types – PAGEIOLATCH Part 2 – Ways to Mitigate It (9 minutes)
  • Wait Types – RESOURCE_SEMAPHORE (33m)
  • Wait Types – SOS_SCHEDULER_YIELD (44m)
  • Wait Types – THREADPOOL (27m)
  • Wait Types – WRITELOG (12m)

SQL Server training, consulting, and thousands of pages of free help.

Get the newsletter

Training

  • Live classes
  • Recorded classes
  • Corporate training
  • Log In

Free Help

  • First Responder Kit
  • Blog
  • Videos
  • Newsletter

Company

  • Consulting
  • About
  • Contact
© Brent Ozar Unlimited®. All rights reserved. · Privacy