RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.
In today’s blog posts that I have written about SORT IN TEMPDB which can be started on this topic. My client asked me how to speed up index rebuilding.
I really really enjoy building SQL in Sixty Seconds video. This month’s topic was Forwarded Records, Backup, and SSMS. Released videos for Feb 2021.
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.