Home Forums SQL Server 2008 SQL Server 2008 Administration Wait Type Suspended Wait Type CXPacket Request Command Insert RE: Wait Type Suspended Wait Type CXPacket Request Command Insert

  • July 27, 2014 at 8:44 pm

    #1732688

    GilaMonster (7/27/2014)

    You have an expensive, long-running query. That's about all that can be said from the details given. If you want to know more, figure out (from the DMVs) who's running the query and go and ask them about it.

    I am to blame.

    Someone entered a bunch of records. I killed the job after 22 hours.

    Thanks.:-)

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/