Skip to main content

Hi, 

We recently conducted a production upgrade, and as a result, the end application has become significantly slower. We've observed that the following procedure is being invoked for each user. It appears that this procedure is called during startup, leading to a prolonged delay. How can we address and resolve this issue?

/* Create or alter stored procedure get_gui_elemnt. */ 

  • session_id 151, cpu_time: 212742, total_elapsed_time: 750783
  • session_id 153, cpu_time: 251607, total_elapsed_time: 1344832
  • session_id 160, cpu_time: 240716, total_elapsed_time: 1293270
  • session_id 178, cpu_time: 250101, total_elapsed_time: 623093
  • session_id 231, cpu_time: 133600, total_elapsed_time: 436721

GUI version: 2023.1.10.0.1 

Windows GUI and Universal are slow.

 

My second question is: Can someone explain to me the origin of this query and why it is consistently running or suspended?

(@source nvarchar(256))SELECT type, data FROM sys.fn_MSxe_read_event_stream (@source, 0)

session info: 

  • host_name: DB4C000001
  • program_name: TdService
  • nt_domain: NT AUTHORITY
  • login_name: NT AUTHORITY\SYSTEM 
  • status: suspended 
  • cpu_time: 12
  • total_elapsed_time: 1760436

The query in question is causing performance concerns, and I would appreciate insights into its source and the reasons for its persistent execution or suspension.

Hi Gosia,

Before answering your questions, let me ask you some questions first 🙂

  • What is the platform version you are using?
  • Is the application started against IAM or the SF?
  • Are you up to date with all hotfixes for this product?
  • Did you run tsf_optimize before collecting the results?

Hi @Jeroen van den Belt ,

This issue was urgent, and I also sought help through other channels. I've already received some tips to improve performance. My apologies for forgetting to mention it here and for closing/withdrawing the ticket.

 

Best answer I got:

“ The get_gui_elemnts can be a bit slower duo to an index issue in IAM or having to many old version in IAM. If you performaned a platform upgrade it could be that is previously was configured with a recompile and this recompile setting was lost during the platform upgrade.

The 2nd query I do not know. Cannot help you there. Might be a something related to performance monitoring. “ 

 

Kind regards,

Gosia

Terms & ConditionsCookie settings