Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Profile trace - what processes are not logged

  1. Advice
0
Votes
Undo
  1. Paul Shue
    Paul Shue
  2. PowerBuilder
  3. Thursday, 30 November 2023 15:32 PM UTC

Most of the time when we have a PowerBuilder process that seems to be slow, a profile trace log helps to pinpoint where the slowness in happening. However we now have a process that is taking much too long by watching and yet the log does not have any long running areas of code so I am wondering what kind of things would not get logged that do take significant time?

PB version:

SQL Server Management Studio 15.0.18424.0
SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.19041.3636
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19044

Response window hangs then app closes
Making data window display only makes drop-down-li...
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 1 December 2023 16:07 PM UTC
  2. PowerBuilder
  3. # 1

Hi Paul;

  FWIW: Then you might want to take a look at the DML interaction between your App & the DBMS using a detailed SQL Trace, For example: 

  • SQLCA.DBMS = "XXX"                  // Current SS DB Client driver
  • SQLCA.DBMS = "TRACE XXX"       // SQL TRACE enabled

HTH

Regards ..> Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.