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 |
|
sponguru_dba
Yak Posting Veteran
93 Posts |
 Posted - 2009-07-16 : 05:01:30
|
| Hi allI have servers setup like thisMain Server(SQL2k) --> ClientServer(SQL2k)Main Server(SQL2k) --> ClientServer(SQL2k5)I have one procedure running on clinet server(SQL2k) and Updating Data in main server(SQL2k) running very fastIf I ran same procedure from clinet server(SQL2k5) it is very slow. both databases having same compatability(80).is it reason..can some body have any idea what may be the reason. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-07-16 : 10:02:35
|
| Can't say without seeing the statement. But there are certainly differences between the two versions. I'm not at all surprised if even with both set to the same compatibility level that there are still fundamental differences in the way the internals work. Since they are physically different machines there could be hardware and configuration differences as well. If you can't find a way to have the same code on both with acceptable performance then you may need to have a different version for each - although I'd be surprised if that was necessary. Have you compared the query plans?Have you confirmed that indexes are intact and statistics are up to date on the slow box?Is it possible that the "client" box has a lot more contention? And perhaps blocking?Be One with the OptimizerTG |
 |
|
|
|
|
|
Performance Issue between SQL2k vs SQL2k5