August 29, 2008 at 10:44 am
I have 2 servers. The OS on both is the same 2003 Ent. SQL 2005 is 64 bit
ENT on one with SP2 and 64GB of RAM and 32 bit Standard on the other with
SP1. We are using a 3rd party application and the application builds its
sql dynamically. Now here is the problem. The older 32 bit server run
better and in tracing it seems that it handles cursors MUCH better then
the newer server but only with this application. The vendor claims to know
nothing, which they always do. Anyone have any ideas? Config options i can
try? We are even not applying sp2 on the 32 bit server in hopes of not
ruining a good thing but the application database must move to the newer
database server. Thanks!
Dave
August 29, 2008 at 12:31 pm
What's your storage situation? Is tempdb on it's own drive array?
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply