Skip to main content
Announcements
Jan 15, Trends 2025! Get expert guidance to thrive post-AI with After AI: REGISTER NOW

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: