Notifications

73 views

Description

The Collect Table Per Hierarchy Stats job and Collect Table Stats jobs can lead to daily flushing of the TableDescriptor cache and performance degradation, transaction delays occurring when attempting to load any form for the first time ie. modification of forms, creating record producers, setting up rules, etc.

The delays often are accompanied by a small pop-up window at the top of the screen that provides "transaction delay-___ sec

In the transaction logs you will see a high cache build time at the end of the transaction.

e.g

2019-07-26 12:11:30 (626) Default-thread-2 D164B48F1BB63B8042FB0D01CD4BCB3C txid=8484b8431bf6 EXCESSIVE *** End #2982253 /slushbucket.do, user: abc.xyz , total time: 0:00:22.486, processing time: 0:00:22.486, SQL time: 0:00:07.351 (count: 11,142), ACL time: 0:00:00.028, Cache build time: 0:00:20.033, source: 103.6.158.98 null

Note the high Cache Build time: Cache build time: 0:00:20.033

Steps to Reproduce

This is hard to reproduce on a non-production system. However, it can be approximated by creating many tables on any instance and simulating enough traffic.

  1. Have an instance with around 10000 or more tables
  2. Run the "Collect Table Per Hierarchy Stats job" by executing from sys_trigger as maint
  3. Review the localhost logs and observe full TD cache flush
  4. If the load can be simulated during the period immediately before and after the cache flush you can observe several threads will need to call createSchema0 leading to a longer response time while building the necessary cached entries.

Workaround

This issue is under review. If you are experiencing this problem, contact ServiceNow Technical Support.

Meanwhile to avoid the issue, you can safely have these jobs set to run every 30 days instead of every day. 

NOTE: These jobs collect recordCount() from multiple tables and it should not typically matter as we can do that once every month.


Related Problem: PRB1309544

Seen In

SR Shodan Kingston r1 - v5.0.10
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - Audit Management PA Content - Madrid 2019 Q1
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Policy and Compliance PA Content - Madrid 2019 Q1
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - Risk Management PA Content - Madrid 2019 Q1
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - CMDB CI Class Models - 201908
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Check Point Integration - New York 2019 Q3
SR - SIR - Exchange Online Integration - New York 2019 Q3
SR - SIR - Exchange OnPrem Integration - New York 2019 Q3
SR - SIR - Have I Been Pwned Integration - New York 2019 Q3
SR - SIR - MetaDefender Integration - New York 2019 Q3
SR - SIR - PhishTank Kingston r1 - v5.0.9
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Splunk Sighting Search Integration - Madrid 2019 Q1
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - SIR - TaniumV2 Integration - Madrid 2019 Q2 2
SR - SIR - Threat intelligence - New York 2019 Q3
SR - SIR - VirusTotal Integration - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2
SR Hybrid Analysis Kingston r1 - v5.0.9

Intended Fix Version

Paris

Fixed In

Orlando Patch 5

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-06-29 12:38:48
Published:2020-05-15