Microsoft SQL Server forum - Tuning API CURSORS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Tuning API CURSORS

kmounkhaty@yahoo.com

2005-11-22, 3:23 am

Hi Guru,

My company, every thing we need is to buy from a vendor. However, we
have PEOPLESOFT CRM app that has around 6000 tables and around 5000
views and none stored proc. We start seeing the slowness of the app.
When I started running a trace to capture some data, and there is no
useful info other than built-in API sp cursors in the following below:
sp_cursoropen
sp_cursorfetch
sp_cursor
sp_cursorclose

What is the best way to capture SQL statements when I see very high
READS? If I tell the peoplesoft prorammer guy to capture SQL statements
from application, will he be able to do it?

I just need the SQL statements to look at execution plan before I throw
out some useful indexes.

Please help!

Thanks so much,
Silaphet,

Sponsored Links