Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insert is taking long time. Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 5:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 26, 2014 7:36 AM
Points: 229, Visits: 730
hi team,

Insert one records is taking 8 to 1o seconds, indexes,stats every thing is good.
i've rebuild the indexes also,

same table in other environment is taking fraction of second.

any suggestion please...
Post #1463489
Posted Friday, June 14, 2013 6:09 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:11 PM
Points: 4,281, Visits: 3,721
Could you give us a little more to go on? The DDL to create the table and something about the insert that's taking a lot time would be a good place to start.

As a shot in the dark:

What indexes do you have on the table where you're having a problem? If it is over-indexed, that will have an impact on performance.

Do you have any triggers on the table where you're having the problem. These have a significant impact on inserts.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1463505
Posted Friday, June 14, 2013 6:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 1,191, Visits: 9,888
Other things to check:

1) Is it a foreign key column in another table?

2) Is the delete getting blocked
Post #1463510
Posted Sunday, June 16, 2013 9:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 13, 2013 3:23 AM
Points: 2,415, Visits: 84
Hi,

I am also facing same problem and in my table i have one clustered and two non-clustered index's, two types of triggers INSERT/UPDATE and i don't have foreign keys in the table, but still insert is taking time and due to this i am getting deadlock also.

Post #1463965
Posted Monday, June 17, 2013 4:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:10 AM
Points: 34, Visits: 148
bslchennai (6/16/2013)
Hi,

I am also facing same problem and in my table i have one clustered and two non-clustered index's, two types of triggers INSERT/UPDATE and i don't have foreign keys in the table, but still insert is taking time and due to this i am getting deadlock also.



In this scenario, I'd be suspicious of the triggers causing the slowdown. Are they complicated, and do they perform lots of inserts/updates themselves? I tend to use more Merge and Output statements rather than triggers now.
Post #1464055
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse