sql server (alternate): 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,

kmounkhaty@yahoo.com (smounkhaty@bremer.com) writes:
[quoted text, click to view]

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