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).
Slow Query
Windows GUI
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
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.