insert taking almost 2 minutes

• mgraulich

  Ten Centuries

  Points: 1294

  More actions

  October 13, 2006 at 8:06 am

  #61558

  I am supporting a third party app and batch process I have at night has been running slower and slower. I profiled this last night and noticed that inserts into a particular table were taking up to 2 minutes to complete. What would cause an insert to run so slow? Assuming no other processes are running on the server at that time and the showcontig is returning an acceptable scandensity/logicalfrag count.

• rogerboltz

  Grasshopper

  Points: 20

  More actions

  October 13, 2006 at 8:51 am

  #665760

  The first thing I would look at is triggers on the table being inserted.

  The second thing I would look at is indexes and foreign key constraints on that table.

  
  ALL Reality is Virtual...