Insert in a table is slow

[skdas]

I have one table, it is observed that recently the insert rate is slow.

Just want know, how to diagnosis it, what is the solution...? Any script any one has to diagnosis this problem..?

[Sathy]

Check with Triggers and indexes belongs to that table..

--Sathy

[skdas]

No triggers are there. Indexes are there and earlier also it was there..

[Scorby]

We would need more information, such as:

How are you inserting rows ? Is it from an application or a SQL script ? Are you using buffered inserts or one row at a time ? Is the table very wide (e.g. hundreds of columns) ? How many indexes do you have ? Have you tried dropping the indexes and doing the inserts to see if the speed increases ? Are there any database constraints on the table ?

[marist89]

http://marist89.blogspot.com/2005/07/trace-it_04.html