![Workspace Memory / Query Memory Tuning – RESOURCE_SEMAPHORE / IO_COMPLETION / SLEEP_TASK Waits | SQLWorkshops.com Blog Workspace Memory / Query Memory Tuning – RESOURCE_SEMAPHORE / IO_COMPLETION / SLEEP_TASK Waits | SQLWorkshops.com Blog](http://blog.sqlworkshops.com/wp-content/themes/twentyeleven/images/headers/lanterns.jpg)
Workspace Memory / Query Memory Tuning – RESOURCE_SEMAPHORE / IO_COMPLETION / SLEEP_TASK Waits | SQLWorkshops.com Blog
![SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende](https://dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-sp_WhoIsActive-show_own_pid-show_system_spids-show_sleeping_spids.png)
SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende
![SQL Server performance monitoring - identifying problems using wait statistics and query wait analysis SQL Server performance monitoring - identifying problems using wait statistics and query wait analysis](https://solutioncenter.apexsql.com/wp-content/uploads/2017/10/word-image-37.png)
SQL Server performance monitoring - identifying problems using wait statistics and query wait analysis
![sql server - Why does a Columnstore index build often wait on SLEEP_TASK? - Database Administrators Stack Exchange sql server - Why does a Columnstore index build often wait on SLEEP_TASK? - Database Administrators Stack Exchange](https://i.stack.imgur.com/cMgKU.png)