I have 2 servers, one is 2000, the other is 2005, sp1. The databases are identical, because I am restoring the database from the 2000 server onto the 2005 server.
I am running some stored procs on both servers. They take about 30 seconds on 2000. However, on 2005, they are taking like over 15 minutes to run!!
This is crazy. Looking at the execution plans, they are MUCH more complicated on 2005, for the *exact* same stored procs.
The stored procedure themselves aren't even that complicated. Yes, they use inline functions, but so what. This difference in performance is shocking.
Any ideas??? I'm stumped.
Thanks
I am running some stored procs on both servers. They take about 30 seconds on 2000. However, on 2005, they are taking like over 15 minutes to run!!
This is crazy. Looking at the execution plans, they are MUCH more complicated on 2005, for the *exact* same stored procs.
The stored procedure themselves aren't even that complicated. Yes, they use inline functions, but so what. This difference in performance is shocking.
Any ideas??? I'm stumped.
Thanks