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
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