I have seen some of my clients use a "with no lock" to try and avoid these timeouts, but I am wondering if this actually is beneficial in any way since activities seem to run in this queue fashion.
Can anyone describe/confirm when and how queries are run against data extensions and if no lock actually holds any benefit?
5 risposte
Found the answer years later with the SQL Server upgrade:
Salesforce Marketing Cloud SQL queries automatically use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED, which is equivalent to WITH (NOLOCK) in SQL Server. This ensures that queries do not block due to other SQL updates. Therefore, you do not need to explicitly use NOLOCK or its equivalent in your Salesforce Marketing Cloud queries. https://help.salesforce.com/s/articleView?id=sf.mc_as_sql_reference.htm&type=5
