Posted by Erland Sommarskog on 11/23/05 00:55

kmounkhaty@yahoo.com (smounkhaty@bremer.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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]