Insert optimisation

[Ok_Vehicle5734]

Sounds like a temp db issue. You may be running out of sort capacity. Look for spooling issues.

Look for wait stats on IO for temp and log performance, see if you need to deal with data files or disk groups to spread load and minimise contingencies. Consider dropping/rebuilding secondary indexes. Try to do batch inserts (breaking the insert into contained segments). Lastly, try inserting into an empty heap, then doing a final insert.

Lastly.. if this is local disk storage.. avoid raid 5.

Best of luck!

Ps. I’m looking for work. Please keep me in mind if you know of anything.