Product has been added to your cart.

Wait Types – RESOURCE_SEMAPHORE (33m)

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.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Fundamentals of Server Tuning with Wait Stats
  7. Wait Types – RESOURCE_SEMAPHORE (33m)
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.
Menu