Posted by kmounkhaty@yahoo.com on 11/22/05 05:24

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,

[Back to original message]