. "You will probably find that there is a resource such as disk io that the spid is waiting on meaning the cpu is idling for the query until disk read/ writes completing." . . .