Tuning API CURSORS

[kmounkhaty]

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,

[Erland Sommarskog]

km********@yaho o.com (sm********@bre mer.com) writes:

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.

I may be wrong, but I seem to recall that with one of these, I think it
is sp_cursor, you see the query text as parameter. You may have to look
in the lower pane for such an entry.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx