Post reply

Random Slowness in Insert operation

  • December 20, 2011 at 8:54 pm

    #247966

    We have SQL SERVER 2008 R2 64bit and Windows 2008 as OS in our production environment.Our database is being hitted heavily everyday.Generally all the insert operations are taking 30 - 40 ms to be completed,but recently randomly some of the Insert operations are taking 2 sec to complete.Our insert operation is very time sensetive and it should be below 1 sec.

    We do not have any page split and all of the statistics of tables are uptodate.Also we do not have any File growth in our database,during the insert operation.When I checked the wait Times,I got below(attachment):

    WaitType Wait_S Resource_S Signal_S WaitCount Percentage

    ONDEMAND_TASK_QUEUE5126704.495126702.442.05 2044893

    LCK_M_SCH_S 76931.25 76931.17 0.08 267 1.4

    CXPACKET 64295.91 53534.9 10761.02 151448841.17

    I would appreciare if someone help me.

    Thanks

  • December 20, 2011 at 11:05 pm

    #1424010

    Please post responses to this thread

    http://www.sqlservercentral.com/Forums/Topic1224842-391-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 20, 2011 at 11:05 pm

    #1424011

    Normal blocking, I would say. What does the table you're inserting into look like and which column is the clustered index on?

    Sorry... posted at the same time as Jason... moving to the other thread. No more posts here, please.

    --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 3 posts - 1 through 2 (of 2 total)

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