Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: No lock option in SQL Server connector

Ashish Kambiri User

Hi,

We have a very high transaction SQL server from which we want to sync the data to snowflake at a near realtime frequency (1 - 5 mins.)
We configured SQL server connector with CT for the system and observed that the read query is taking a lock on the tables and because of which some of our critical operational tasks are waiting.
We had a discussion with the Fivetran support team and it seems that the Teleport sync options also takes a lock.(ruled out due to near real time requirement as well)

We also ruled out CDC and HVAC as an option because the system is highly transactional and CDC will put a huge load on resources.

 

It would be helpful if there could be an option to read the data with NO LOCK option for scenarios where dirty READs is not a problem for the business.

 

Thanks

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Tyler Netherly User

    We have the same problem with the SQL Server connector using Teleport Sync. Syncing our main connector during the day locks up several critical tables. Adding a NO LOCK option would be highly beneficial and allow us to sync data much more frequently.