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 |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2007-10-30 : 11:35:22
|
| I have one query which is calulating running total and taking just 6 mins to run on production SQL Server 2000 server but it is taking more than 45 mins to run on QA on SQL Server 2005 server. The index and data is same on both server, What other things we can check beside the index?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 11:39:41
|
| Did you change the Compatibility Mode to 90 and rebuild all indexes and statistics after migrating from SQL 2000 to 2005 ?Kristen |
 |
|
|
richard75013
Starting Member
19 Posts |
Posted - 2007-10-30 : 11:46:25
|
quote:
Originally posted by sanjnep
I have one query which is calulating running total and taking just 6 mins to run on production SQL Server 2000 server but it is taking more than 45 mins to run on QA on SQL Server 2005 server. The index and data is same on both server, What other things we can check beside the index?Thanks
there are several fixes that SP2 has that delt with performance differences between 2000 and 05 RTM and 05 SP1This is assuming that you are at apples to apples server and san hardware and SQL Server configuration options.Are you at SQL 05 SP2?Thanks..Richard |
|
|
|
|
|
|
Performance issue on SQL Server 2005