O'Reilly logo

Mastering ServiceNow by Martin Wood

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Finding slow database transactions

The transaction log shows an aggregated performance metric for how long the database is involved. So, how would you know whether the database is struggling for a particular query, or your reports and lists have inappropriate filters? The Slow Query log gives you valuable insights 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required