Unable to insert 2 million rows in staging table RRS feed

  • Question

  • Hi

    I need to insert 2 million rows in a staging table as a part of SP. It has been working fine until now. But all of a sudden the process goes into "Suspended" state and no inserts happen. I tried troubleshooting and it says the wait type is "CXPacket"

    Don't know how to proceed from here. if someone can shed some more light onto this that would be really great?


    Monday, May 29, 2017 5:18 AM

All replies