Hi,

Thank you for the replies.

Some answers to your questions:

The wait types I see are CXPackets.

I see a lot of parallel queries during this time - the same parallel queries we had before the migration.

I do weekly index rebuild, reorganize and update of stats and these jobs are always successful.

When I check sysprocesses, do I focus on queries with high CPU usage or mainly long execution time? Or both I guess...