Hi I have a heavy Insert operation job running in the morning.
About 1 million rows are inserted.
I have Server fine tuned based on the best practices like
Decrease DOP to 1.
Disable index on that table are recreate it.
I am constrained with hardware resources and cannot increase physical RAM.
What other aspects I can lok into ?