slow insert

Question

slow insert

sqlstar2011

SSCertifiable

Points: 6000
More actions
September 27, 2010 at 8:44 am

#227081

I am inserting a single row using parameterized values into a table with about 200 columns but it takes forever. there is only index on the table which is primary key clustered index.
wonder why it may be taking this long to insert the record into the table?

Viewing 6 posts - 1 through 5 (of 5 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

What other activity was occurring on the database at the same time? What is the transaction isolation level? Are there any triggers on the table?

John

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 2

there are triggers on the table and isolation level is read committed.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

With the limited information you've provided, then, I would suggest you have a look at what the triggers are doing.

John

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 4

sqlstar2011

SSCertifiable

Points: 6000

September 27, 2010 at 9:01 am

#1227759

what other information would you like me to provide?

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 5

You have primary key clustered index on your table, is it incremental?

What your triggers do?

"forever" is relative term. What is your "takes forever" means? does it time-out? Takes seconds? Minutes?

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]