August 29, 2008 at 10:43 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 11:55 am
brekher (8/29/2008)
I have 2 servers. The OS on both is the same 2003 Ent. SQL 2005 is 64 bitENT 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
If the bottleneck is on IO 64bit or 32 bit would not matter.
check this out to see if it helps :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838857&SiteID=1
* Noel
August 29, 2008 at 12:35 pm
This is a duplicate thread. Please post replies to the copy in General Discussions. Please don't double-post.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply