Finding slow database transactions

The transaction log shows an aggregated performance metric for how long the database is involved. So, how will you know whether the database is struggling for a particular query or whether your reports and lists have inappropriate filters? The Slow Query log gives you valuable insight into how the platform is used. You can access it by navigating to System Diagnostics > Stats > Slow Queries.

The instance uses a concept of total execution time. This is calculated by adding together all the execution times of similar individual transactions. Two transactions are considered similar if their SQL queries are the same, except for the values of the WHERE clause.

 

Note

As a very simple example, these queries are considered similar since only the value of the WHERE clause changes:

SELECT * FROM task WHERE state = 5; 
SELECT * FROM task WHERE state = 3; 

Note

In contrast, the following queries are not similar since they select different information and have dissimilar...