Forum Replies Created
March 3, 2020 at 11:10 am in reply to: Why the minimum requirement of 100 Gb available disk space for Replicator Agent? #10027
We realize that this a very large disk requirement but we have it in place because of the wide range of functionality of the Replicator Agent. Our customers have the ability to create very detailed logs and combining that with the Agent’s ability to process millions of records quickly and any other options the customer enables, it can add up. So we ask that you have 100 Gb disk space because failure to create these giant logs could cause the agent to fail, which could be very hard to recover from.
In short we have that requirement just in case, and to prevent customers from losing records.
Not sure is you’ve seen this documentation, but you can get discrepancy check using table compare
And if checking between servicenow instances (InstanceSync), you can also generate a list of sys_id’s missing locally and automatically create a bulk share for it https://wiki.perspectium.com/doku.php?id=replicator_table_compare
That was for quick smaller lists. I later ran into tables that were missing 200k records. The script is not so good for that many. I created an import table and transform map that allowed me to populate the table a little quicker.
If I want to check my queues, I use this link:
It shows my queues and current number of messages in them.
Temporal Data jpg attached
Attachments:You must be logged in to view attached files.April 24, 2019 at 5:08 pm in reply to: Performance issues when writing to large SQL tables. #7769
There are a few questions we have:
Do you have any insert triggers in your sys_audit table in your database?
And do you have dynamic shares set up for sys_audit table directly?
We suggest try running multiple agents, one for sys_audit table specifically and another for other tables.April 24, 2019 at 3:00 pm in reply to: Performance issues when writing to large SQL tables. #7767
What kind of performance issues are you seeing? We will try to see if we can help you.March 4, 2019 at 10:28 am in reply to: Upgrading SQL Server, Will it break the integration with the Replicator Agent? #7196
We currently support up to SQL Server 2017 on the Carbon Replicator Agent, so there should be no problem with your update to 2014.January 25, 2019 at 5:54 pm in reply to: Forget your default Perspectium Credentials password? #6657
Great post Andres!
Because Replicator is a native app, it is aware and can filter on the sys_domain field of each record to push the appropriate record to the appropriate warehouse.
By default, the data collection is executed using queryNoDomain and can see all records in all domains for you to use the filter.
Click “Get Started” and have one of our solution architects show you how easy it is.