June 14, 2013 at 5:35 am
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...
June 14, 2013 at 6:09 am
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.
June 14, 2013 at 6:12 am
Other things to check:
1) Is it a foreign key column in another table?
2) Is the delete getting blocked
June 16, 2013 at 9:42 am
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.
June 17, 2013 at 4:09 am
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply