Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

In SQL Server if Snapshot Agent is turned on accidentally then we can observe the table locks

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
SwathiPulagam
Support
Support

In SQL Server if Snapshot Agent is turned on accidentally then we can observe the table locks

Last Update:

Mar 2, 2022 3:44:40 PM

Updated By:

SwathiPulagam

Created date:

Mar 2, 2022 3:44:40 PM

Environment

Qlik Replicate 

For one of the customers, we observed that the snapshot agent was running which causes locking on database tables. Replicate never use snapshot agent to sync data as like native SQL replication. After stopping and disabling the snapshot agent no locks were observed.

NOTE: For any reason, if you create Publication manually then we have to make sure that the Snapshot agent is not created/disabled.

Contributors
Version history
Last update:
‎2022-03-02 03:44 PM
Updated by: