October 17, 2002 at 5:32 am
Hi All,
We've recently backed up sql 7 db's and restored them to sql2k. Now we find that even after changing the compatability level to sql2k, reindexing, updating the stats and recompiling the sp's, the web app runs slow.
We profiled and found that when the db compat level was changed back to sql 7 performance was increased as expected. FYI: the old server was a p3 and the new a quad zeon, we've had to turn on all the processors to keep the performance similar to how it used to be on the old server.
October 17, 2002 at 1:34 pm
When we upgraded from SQL Server 7.0 SP3 to SQL Server 2000 we had some stored procedures or some queries in stored procedures that ran much slower than they did before upgrading.
I figure SQL Server 2000 decided to execute them differently. So, I examined execution plans and reworked the slow sections until I got better speed out of the SP's. One SP was completely rewritten and now works better than before. We still have areas that are scheduled for tuning and I suspect these are slower now because SQL Server 2000 handles them differently than SQL Server 7.0.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
October 18, 2002 at 7:29 am
Thx for your help. That seems to have solved my problem. Back to the developers to help review the execution plans and re-write the sp's where required one DB at a time (109 to do).
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply