November 19, 2009 at 4:13 am
maybe your table was pinned on sql2000 ?
that nolonger exists on sql2k5
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 19, 2009 at 5:56 am
Getting there now (the mystery unfolds!)
I can't believe I didn't realise until now but there is a legacy trigger on this table that reports any changes to another "logging" table. It records 1 row for every column changed per record. So in this case it is updating 1700 (no of records) x 1700 (why does an update do this?) so therefore inserting 2.8 million records into the log table each time!!!
So that was the cause. Recreating the table was fixing this because it was dropping the trigger.
Proof was disabling the trigger and running the update (INSTANTLY applied) and countign the number of records inserted into the log table when running the update.
Case closed!!!
November 19, 2009 at 6:30 am
Thank you for the feedback.
Now, let's have a virtual pint on behalf of your solution :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 19, 2009 at 8:37 am
Oh I need it! haha
November 19, 2009 at 9:38 am
Shark Energy (11/19/2009)
Oh I need it! haha
Dammit!! I thought I mentioned triggers up earlier in the thread but I don't see it. Something must have barfed in my send! Coulda had this one solved much earlier. Oh well. :hehe:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply