Check out the solution in the video Wait Types Part IX: SOS_SCHEDULER_YIELD. Before you dive into the system, make sure you understand the architecture, as we expect to see some wait types such as these in our setup.
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
As a general rule: if there's performance issues in an environment where they should not be expected (ie: we have a strong design), I investigate further. However, jumping into solving a performance issue may be a waste of time in situations where resources are heavily restricted, the design is incompatible with our resources, or other situations.
YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security
