Interview Questions
1. What are the components of SQL Server scheduler?
Scheduler
A schedule has three important component, Processor,Waiter List and Runnable queue.
A Processor is the actual processor which processes the thread one at a time.
Waiter List is the list of threads waiting for resources.
Runnable Queue is a queue of threads which has all the resource it need to process but waiting for its turn to get into the processor.
Scheduler put the thread in to Runnable Queue then move the thread to Processor and migrate to Waiter List. Each thread
keeps going through these three components until the thread works completes
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