How to control blocks and performance on SQL?

Comments

• johanna Member Posts: 369

  2010-11-24

  Hi,
  
  Thank you for this useful tool.
  I have download this tool, but when I click button Show Active Sessions, it result error :

  This program must be run from from 60150:"SQL Session Performance"

  
  How to solve this error so I can open the Show Active Sessions ?
  Thank you.

  Best regards,
  
  Johanna

  0
• kriki Member, Moderator Posts: 8,914

  2010-11-25

  The form you run must be started from form 60150. It is not a form you can run in itself.

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  NAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)
  

  0
• johanna Member Posts: 369

  2010-11-26

  Hi Kriki,
  
  Thank you for your reply. I have run form 60150 then clicked the button "Show Active Sessions" and got the error result "This program must be run from form 60150:SQL Session Performance".. How to solve this error? Thank you.

  Best regards,
  
  Johanna

  0
• kriki Member, Moderator Posts: 8,914

  2010-11-26

  First you need to put "Log Active Sessions" to true.
  
  This logs in a temptable the records where a session uses too much resources (see the fields on the form). If no logs are made, you get that error.
  
  To have some logs easily, do this:
  "Log Active Sessions"=true
  "Log only blocks"=false
  "Beep on heavy *"=1
  
  Open another session (if no other session is working) and do something in there.
  
  After some moments, you will be able to open the form and see some records.

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  NAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)
  

  0
• johanna Member Posts: 369

  2010-11-29

  Hi Kriki,
  
  I have tried your directions and it has worked. Now I can access "Show Active Sessions" from SQL Server Performance. Thank you so much. :thumbsup:

  Best regards,
  
  Johanna

  0