• Well, it was set to default one time, but we experienced some timeouts, further investigating the cause of the timeouts, we saw some OLTP processing such as Search stored procedures cause more CXPacket values. so we decided to set it to 1, but that does not help during batch processes in the night time, becasue we get CPU spiked at 100% and make the system unresponsive forother concurrent tasks.

    I'm exploring the option of setting back to default (0) at least during the night time 10 PM to 6 AM.