Hi All,
This is my first article and would like to explain about Wait types and how to Trouble Shoot Wait types in SQL Server.
Below diagram tells that how CPU's are converting in to schedulers in SQL Server terminology. that mean in SQL Server we no more use name as CPU instead we should call them as schedulers
Say Example Server has 1 scheduler, that will take responsibility to process all the requests which are coming to the server.
Say here the 1st requester in the Queue called Running State and standing behind him is called Runnable State in Queue which say some thing is bad if you see Runnable in output of sys.sysprocesses list.
Here in the above diagram Scheduler has some concern about the inputs from the first requester. Hence suggesting to comeback with full details. So 1st requester which is in running should go to Suspect State as below.
