• Log In
  • Contact Brent
Product has been added to your cart.
  • Consulting
    • Performance Tuning
    • Remote DBA Services
    • Upgrades and Migrations
    • Consultant Toolkit
  • Training
    • Conferences
    • My Videos and Downloads
    • My Account
    • Private SQL Server Training
    • Training FAQ
    • Watch Brent Streaming Live
  • Monitoring
  • Scripts
    • sp_Blitz – free health check
    • sp_BlitzCache – find queries to tune
    • sp_BlitzFirst – instant performance check
    • sp_BlitzIndex – design the right indexes
    • sp_BlitzWho – what’s happening right now
    • PasteThePlan – share query plans
  • Blog
    • T-SQL
    • Execution Plans
    • Indexing
    • Videos
    • Architecture
    • Backup and Recovery
    • Cloud Computing
    • Development
    • First Responder Kit
    • High Availability
    • Humor
    • Locking, Blocking, and Isolation Levels
    • Parameter Sniffing
    • Production Database Administration
    • Professional Development
    • SQL ConstantCare
We usually think of SQL Server’s memory being used for caching data pages and for caching execution plans, but there’s a very important third consumer: query workspace memory grants. Queries need memory in order to sort stuff, join tables together, and even parallelize operations. In this module, we’ll show what happens when queries can’t even...
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.
  • 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 – SOS_SCHEDULER_YIELD (44m)
  • Wait Types – THREADPOOL (27m)
  • Wait Types – WRITELOG (12m)

© Brent Ozar Unlimited®. All Rights Reserved.
Privacy Policy – Terms and Conditions

  • Consulting
  • Training
  • Monitoring
  • Scripts
  • Blog

Save your cart?

x