Post reply

sp_server_diagnostics_sleep

  • June 30, 2021 at 9:16 am

    #3901967

    Hi,

    we are trying to bulk write the data in the table. but the process seems to get slow. On checking the wait type, i found continuous records of sp_server_diagnostics_sleep. Couldn't find the real reason for the latency of bulk insert in the table.

    Kindly help

    Saumik Vora

  • June 30, 2021 at 8:42 pm

    #3902246

    If you want help on this, and there are a large number of people that can help with this on this forum, you're going to have to provide more information than that.  Some of the DDL involved, what the source of the data for the bulk insert is, what the target table and all the constraints and indexes look like, how many rows and files you're talking about, it a merge or a replace, etc, etc.

    Heh... you can't figure it out and you're actually there and have all the information.  How on Earth do you expect any one to help you "fix the car" when you won't even identify which car in the lot is yours? 😀

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply