Interview Questions
1. What is a scheduler in SQL Server?
(SOS Scheduler)– The object that manages thread scheduling in SQL Server and allows threads to be exposed to the CPU
(described in sys.dm_os_schedulers). It does not control things but lets the workers work with each other and relies on their
cooperation (co-operative scheduling mode). Each scheduler /master (one per logical CPU) accepts new tasks and hands them
off to workers. SOS Scheduler allows one worker at a time to be exposed to the CPU.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment