Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.
Some of the learnings can lead to another exploration when someone does stump you with something you didn’t know. To understand the basics of batch mode and row mode, read the blog SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode where I have explained the concepts. This…Read More