Skip to main content
Closed

Slow Query

Related products:Windows GUI
  • July 15, 2022
  • 2 replies
  • 80 views

Forum|alt.badge.img+1

When a query is slow and takes more time then for example 1 minute create automatic a log to the thinkwise folder (no database action).

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Software Architect
  • August 15, 2022

Hi Peter,

Long running queries is something that can happen for many reasons. It may be even intended to be a longer running process thus making it very difficult to decide a query is considered slow or not. We rather recommend using external tools to monitor your Thinkwise applications.

For example, the SQL Server Query store is one tool you can use that automatically monitors your database; Robert-Jan made a blog about this here:

I also want to refer you to this blog from Anne. This gives an extensive overview of performance troubleshooting and what you can do to resolve it : 

We are not planning to implement this idea so I'll close it.


Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Software Architect
  • August 15, 2022
NewClosed