December 7, 2009 at 12:56 pm
I am migrating a database from a sql server 2005 instance on windows server 2003 to a sql server 2005 instance on windows server 2008 32bit. In this database there are a couple of stored procedures that reference views that reference data from a production server. on the origional server the stored procedures and view run just fine, however, when i move them over to the new server they run very slow. the new server is an upgrade compared to the older server.
I have noticed that the query plan between the two servers is completely different, i believe that is probably what is causing the problem. What would cause the plans to be different? Is there a way to fix this?
December 8, 2009 at 8:27 am
Are both servers 32-bit? Are there differences in server hardware? Is there any data on the local server or is it all remote?
Can you post the 2 different execution plans?
Edit: added request for execution plans.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 8, 2009 at 8:41 am
How did you migrate things? Are you sure statistics are up to date?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply