We insert/delete about 1 million rows of a two million rows table with SSIS.
We have 20 indexes on this table.
Right after the SSIS finished, we're experiencing timeouts in the frontend. The timeouts eventually go away.
I'm suspecting the indexes are causing this during re reorganisation of them.
What can we do?