Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sparrow
Starting Member
20 Posts |
 Posted - 2008-12-11 : 16:02:01
|
| I’ve rebuilt all my data loads in integrated services, as they are currently part running as DTS package in SQL2000. The first part of the loads tables and the 2nd part is some update statements which use the tables I have populated in the first part.The current loads are running on SQL2000 which is where the DB sits. The new loads are populating a DB on SQL2005I’ve put the same indexes as are on the tables sitting n 2000 on to the ones sitting on 2005 yet when I run the one of the update statements in management studio it takes one and half minutes compared to 1 second for the old version. Both instances of SQL are running on the same server. I have taken he indexes off the of the tables in 2005 and run the query and it takes the same amount of time, it’s like the indexes have no difference. It is not just confined to one query or table as have tried others and still get the same problem.Any help appreciated |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sparrow
Starting Member
20 Posts |
Posted - 2008-12-11 : 16:49:12
|
Nothing else is accesing the DB while the update is runningWhat stastistics showuld i be looking at?As i've just recreated the index on the new loads there shouldn't be any fragmentation.Prior to the update running on the table there is a trucate then load through DTS/intergated.The execution plane looks the same..I posted before that this was running fine, This was incorrect as i was running the query on the old tables Cheers |
 |
|
|
|
|
|
Index issue