title: What happens to CPU when WAITFOR statement is executed in SQL Server?
body: <p>There is a <a href="https://msdn.microsoft.com/en-us/library/ms187331.aspx" rel="nofollow">WAITFOR</a> statement in SQL Server. I want to know what exactly happens with respect to CPU and thread on SQL Server when this statement is executed. Does it use CPU cycles while waiting for the time or the thread goes into suspended mode?</p>