Slow Inserts SQL Server 2005

Posted by Achilles on Server Fault See other posts from Server Fault or by Achilles
Published on 2010-05-06T15:03:14Z Indexed on 2010/05/06 15:08 UTC
Read the original article Hit count: 241

Filed under:
|
|

I'm researching an issue with the following information:

We had a logging table with about 90k records in it that had inserts taking several seconds(approximately 10 to 20s) in extreme cases. One of the columns of the table stores XML as the XML datatype. The XML isn't being parsed during the insert, just stored.

We tried truncating the table assuming that the issue was related the number of records(althought 90k seemed "normal") and the inserts still are performing poorly.

While I know there are other issues that can cloud the issue, what would be some "check this first" ideas that could help me debug this issue? Thanks for any suggestions and help in advance.

© Server Fault or respective owner

Related posts about sql-server

Related posts about database