Occurs when memory request by a small query cannot be granted immediately due to other concurrent queries. Wait time should not exceed more than a few seconds, because the server transfers the request to the main query memory pool if it fails to grant the requested memory within a few seconds. High waits may indicate an excessive number of concurrent small queries while the main memory pool is blocked by waiting queries.
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - RESOURCE_SEMAPHORE_SMALL_QUERY
- Ecosia Search for sqlserver - RESOURCE_SEMAPHORE_SMALL_QUERY
- Bing Search for sqlserver - RESOURCE_SEMAPHORE_SMALL_QUERY