Statistics
The Highest Post







Statistics
Count 94
Avg 21.00
Min 21
Max 21
Angualr Top questions

Details



Step 3 – Monthly instance performance? Don’t let slow queries or transient data bog down your instance. KEY INSIGHTS • Track your table growth to ensure they don’t get too large. • Remove unnecessary records when the data is no longer needed. • Review your slow queries to see if you need to index or change frequent queries. There are broadly two types of data stored in your ServiceNow instance: • Persistent data that you want to retain, such as a task or user info • Transient data that needs to be cleared after a given time frame, such as log information or staging data for imports or integrations It’s normal to see persistent data growth over time. But when you see increased table sizes along with a decreased response time, you may have list definitions or glide record queries that need to be refactored or supported by appropriate indexing so you can accommodate the data growth. Or your data sets may be growing because there’s an increase in response times for end-users and an increase in execution time for maintenance tasks such as cloning, backup, and restore. If that’s the case, it’s important to monitor your table growth on a monthly basis. If you created a spreadsheet to track your top 20 request response times, you can extend it to track the number of rows rendering in your tables, as well as your slow queries, so you can track their improvement over time.
Related Topics