right now read these:
but all these DO NOT give you a hints on how to detect the CURRENT SQL server query's situtation and what signal will tells us we need to change the MAXDROP and degree of parallelism so that overal perfomance is better as we are making use of all available CPY threading?
1) are saying we don't need all query to execute in parallel, is that right? all run in parallel will make the whole SQL server slower?
I don't agree with this as we buy bought the hardware anyway and why just fully utilize that?