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: Thursday, December 4, 2014 4:34 AM
Points: 233, Visits: 739
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 @ 12:28 PM
Points: 4,611, Visits: 4,067
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: Monday, November 3, 2014 8:05 AM
Points: 1,191, Visits: 9,892
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: Monday, November 17, 2014 11:11 AM
Points: 2,416, Visits: 90
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: Tuesday, December 2, 2014 8:32 AM
Points: 36, Visits: 150
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