June 18, 2009 at 6:05 am
We have a script that ran fin in SQL 2000 - we have moved it to a dfferent server and now it is so slow that it won't complete in 2 days
The script is mainly creating new tables
Has anyone else encountered this problem and found a solution??
June 18, 2009 at 3:35 pm
jackiepenn (6/18/2009)
We have a script that ran fin in SQL 2000 - we have moved it to a dfferent server and now it is so slow that it won't complete in 2 daysThe script is mainly creating new tables
Has anyone else encountered this problem and found a solution??
show us the script! 😛 ... also, how's your drive's layout: RAID type, drive partitions, etc ... how much RAM and CPU, etc
July 8, 2009 at 8:43 am
Usually a problem if you haven't updated statistics and updated usage.
It's a good idea to rebuild all indexes to be sure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply