February 20, 2003 at 6:54 am
Our development server is SQL 7 and our production server is SQL 2000. Recently I moved an application from development to production. It runs 4 times faster on 7 than 2000! I did the trace and the index tuning wizard, but nothing seems to help. There is nothing abnormal showing up on the monitor. I have migrated other applications with no problems. Any suggestions?
thanks!
TND
computers make me sing the blues
February 20, 2003 at 7:18 am
February 20, 2003 at 7:35 am
Not sure what you mean.
computers make me sing the blues
computers make me sing the blues
February 20, 2003 at 7:47 am
Run sp_updatestats in the production db, that will make sure you get a good query plan. Do you have the exact same indexes in production that you have in development?
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply