How It Works: Workers, Tasks, Failed Logins – What is my SQL Server Doing?
From Customer
Interesting point here is, current_workers_count is ~10X compared to active_workers_count; means no tasks assigned to 10X threads.
How did threads land with no tasks? Is there orphaned threads not getting cleaned up?
My Notes
T… Continue reading How It Works: Workers, Tasks, Failed Logins – What is my SQL Server Doing?
