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.