Non-yielding issue on SQL Server
Look in your Wait Stats (preferably Query Store Wait Stats, Session Wait Stats, and otherwise System Wait Stats) for preemptive waits.
Sessions enter preemptive waits when calling into code that doesn't participate with SQL Server's cooperative scheduler, which is a common cause of a session refusing to yield a scheduler (CPU Core).