Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54

    Unanswered: SQL 2008 trace and PeopleSoft

    I've got a SQL 2008 Profiler Trace of a long running session. The client code is all PeopleSoft 8.9, so (by design) literally EVERY SQL batch is either a client cursor prepare or a fetch.

    Does anyone have a clean way to extract the Application's SQL statements from this Trace File so that I can prepare and analyze the Application's SQL for performance?

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    Best I have come up with is a script that polls the sys.dm_exec_session and sys.dm_exec_sql_text DMVs, and spit that out to a text file. WebLogic also leans heavily on sp_prepare, and sp_execute. In order to be sure you get all the statements, you pretty much have to start the trace when the WebLogic service starts, because it looks like they cache a lot of queries up front, and use those throughout the life of the instance.

  3. #3
    Join Date
    Jul 2003
    San Antonio, TX
    I wrote this script a while back, but it still works against 2K8, as well as 2K5SP3.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts