The Generate performance stats logs option in Perspectium Properties enables the creation of records in the PSP Message Performance Stats (Perspectium > Replicator > PerformanceStats) table. This table profiles the performance of DataSync for ServiceNow activity.
Prerequisites
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 Perspectium > Replicator > Performance Stats. Each record in the PSP Message Performance Stats table contains the following fields:
| Field | Description |
|---|---|
| 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. |
| Duration | Total time taken to process all records of that given table |
| Records | Total amount of records processed for that given table |
| Records Per Second | Total 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 |
