Jeff: Not quite sure I understand.

in the meantime, I don't know how I overlooked the following...

The update of 3 million rows took 27 seconds without my original trigger. While doing...

• This reply was modified 4 years, 6 months ago by  JohnG69.
• This reply was modified 4 years, 6 months ago by  JohnG69.

Very good point.  The thing is that we kept all the audit info in text files until we introduced the auditing tables.  When installing our 30-year-old evolving software, although it's...

So I moved my tests to another machine and ran the Paul Randal Script that measure IO latencies... My machine has over 200 ms of IO read and write latencies...

I agree with you but to fix the trigger for it not to spill, I would think that if I insert smaller chunks at a time in the audit table...

When the software is installed on one of the local test box, the update took 9 minutes and on my test box it took 4 hours (my test box isn't...

That response was for Aaron... after my first response to him, I noticed that I didn't answer all of his questions.

With all the reading and analysis' that I've been doing based on Paul Randal's Wait Stats articles, I come to the conclusion that the issue is an IO subsystem issue......

The trigger is already in place and I can't just change the logic of inserting the deleted records when We already started inserting the inserted records.

The Diff is necessary due...

Unfortunately, the actual table has 200 columns and I can't change the structure 🙁

But regardless of the number of columns, I'm able to reproduce the issue with the example I...

I can't Assume that they do not do larger volumes and since they are customers of our software, we can't force them to upgrade MS SQL Server.  🙁

As I mentioned to Ken, I have to support SQL Server and SQL Express 2005 and up... The only index on the history table is the NC index. It used...

Unfortunately, I have to support all versions from SQL Server and SQL Express 2005 up until today.

unfortunately, I can't change the structure... they want me to fix the trigger...

I don't have a problem if I insert smaller batches but I can't control the number of records...

Lynn Pettis,

In our case we can't serialize the code... Initially the code was made to run single threaded and now they have decided to split the processing based on store...

Gila Monster, It's exactly the thought I was having... I Would need to write a whole SQL command parser!!!! LOL