Upgarding

Hi,

I have upgraded my server from 6.5 to 7.0.The application is running
on PowerBuilder 6.5.After upgrade the performence of application is
down by 200 % .The application basically validates claims.All the code
is written in front end except for one trigger.When i ran a trace on 7.0
i found s system stored procedure SP_cursoropen which is taking more time.
I found from 6.5 trace for same data the same procedure is taking very less
time.I came to know from BOL that this procedure is used internally by
SQL server to deal with server side cursors written from front end
application.Is there any way to tune the server to improve performence.
I found a configuration option Cursor_Threshold .Can any one suggest me
about this configuration option?
Thanks in Advance
Mohan