The Generate performance stats logs option in Perspectium Properties enables the creation of records in the PSP Message Performance Stats (PerspectiumReplicator > PerformanceStats) table. This table profiles the performance of DataSync for ServiceNow activity.

Prerequisites


(warning) First, you will need to install DataSync for ServiceNow and run the Perspectium Finish Install scripts.

Procedure

To generate performance stats logs in the PSP Message Performance Stats table, follow these steps:


Access Perspectium Properties

Log into your sharing ServiceNow instance and navigate to Perspectium > Control and Configuration > Properties.

Enable generation of performance stats logs

Check the box labeled Generate performance stats logs. Then, scroll to the bottom of the form and click Save to save your changes. To view your ServiceNow instance's performance stats logs, navigate to PerspectiumReplicatorPerformance Stats. Each record in the PSP Message Performance Stats table contains the following fields:

FieldDescription
Job

Type of job for the message

e.g., Subscribing or Sharing

Action

Status for the message

COLLECTED = Completed and performance stats compiled for the message

PROCESSING = Gauges the performance of records within the same table. If a batch of records contains multiple tables, the PROCESSING record will display the overall performance of each table within that batch.

DurationTotal time taken to process all records of that given table
RecordsTotal amount of records processed for that given table
Records Per SecondTotal amount of records processed for that given table per second
Table Name

Name of the table and action

e.g., incident.bulk = a ServiceNow bulk share performed on the Incident table