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 ...
Get Mastering ServiceNow - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
