Everything has been running smoothly, then yesterday for nearly 6 hours, I had an SSIS job fail. DPA reported that the following SQL query spent 6 hours of which 98% was PREEMPTIVE_OS_WRITEFILEGATHER.
The only thing I found related to that message was to do with Log files being too big or autogrowth being too small/frequent. Either way I don't really understand what can be done. Also, since that 6 hour period, this sql plan has spent no more than 18 min.
What is this sql even doing? This is not something I have instructed the server to do, so it must be some automatic maintenance? I've attached the Query Advice from DPA as well as the SQL Plan.
