Reviewing my top waits graph, I am seing a lot of CXPACKET waits. I am looking for a suggestion pertaining to this particular SQL server and that one database running on it.
It's a bare metal box with 12 physical cores running the Orion database and nothing else. Since Orion is an OLTP database, would disabling parallelism make sense or should we focus on the queries?
I hope to get some joint input from the DPA and Orion core boffins.