2 Replies Latest reply on May 12, 2017 9:18 AM by gwsmike

    PREEMPTIVE_OS_WRITEFILEGATHER on SSISDB?

    gwsmike

      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.