curious_sqldba (2/28/2014)

---

I have read so many articles, may be i am just missing the point. My understanding is you set your CTP and MAXDOP, if the cost of a given query is greater than set CTP then SQL Server MIGHT use upto number of processors specified in MAXDOP.

MAXDOP = 4 , CTP = 20 ( Server has 24 logical cores, right click -> task manager )

All queries who cost is > 20, each operator might use upto 4 cores --- Is there a possibility it will use less than or more than 4?

What happens when cost is less than 20, queries might use all 24 cores? I couldn't find a article which talks about the impact when cost is less than set CTP value.

Appreciate if someone can clarify and point me to a good article. Thanks