Cursor Issue

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Blogs QotD Books SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Cursor Issue

Cursor Issue

Rate Topic

Display Mode

Topic Options

Author

Message

brekher

Posted Friday, August 29, 2008 10:44 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, June 19, 2009 10:48 AM
Points: 37, Visits: 99

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

Post #561366

Jack Corbett

Posted Friday, August 29, 2008 12:31 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:24 AM
Points: 6,301, Visits: 5,577

What's your storage situation? Is tempdb on it's own drive array?

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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

Post #561429

« Prev Topic | Next Topic »

Permissions