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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-01 : 11:20:17
|
Eli writes "I recently encountered a performance problem when I upgraded a SQL 7 database to SQL 2000.
Performance in SQL 7 was very good and got worse 10 times in the 2000.
The indexes and all design structure is well built and all SP are not dynamic and at most 3 tables are in a single join query.
The Database was planned for best performance and worked fine on an NT 4.0 server with SQL 7. (1 processor)
The Targer Server is win 2k with sql 2000 standard edition. (2 processors)
What seems to be the problem,
I thinks its the work of the query optimizer that handles queries differently in SQL 2000 But how can it be changed?
Thanks
Eli." |
|
|
|
|
|
Upgrading to 2000 performance problem