ServiceNow: Building Powerful Workflows

Examining the Slow Query log

A development instance is unlikely to contain the same sort of results as a heavily utilized production system. My development instance spends the vast majority of its time on scheduled jobs. In fact, there are no user-initiated transactions that have taken a total execution time of more than 5 seconds.

Lets find some queries that fall into this last category and are candidates for optimization:

1. Navigate to System Diagnostics > Slow Queries and create the following filter:

Average execution time (ms) - greater than - 1000

Example URL - starts with - /

2. Order by Total execution time (ms), with the z to a condition, so the largest is at the top:

This should return a list of database queries that should have ...