Which of the following wait types would indicate excessive CPU consumption?

The wait type SOS_SCHEDULER_YIELD is closely associated with excessive CPU consumption. This wait type occurs when a thread has used its allocated CPU time but must yield execution to allow another thread to run. A high number of SOS_SCHEDULER_YIELD waits suggests that the system is experiencing contention for the CPU or that there are many threads waiting for processing time. Essentially, this wait type is a signal that the system may be overloaded with tasks competing for CPU resources, often indicative of high CPU utilization.

In contrast, other wait types listed serve different purposes. PAGEIOLATCH_SH relates to page input/output operations, indicating that the SQL Server is waiting for disk page reads, which is more about disk I/O performance rather than CPU consumption. LOCK_S involves wait times associated with locking mechanisms in SQL Server, typically during resource contention rather than CPU saturation. Lastly, SLEEP_TASK indicates that a thread is simply waiting in a suspended state, which is not directly indicative of CPU consumption levels; it's more about timing out or waiting for another operation to complete.

Understanding these different wait types and their meanings helps database administrators optimize performance and address potential bottlenecks in resource utilization.