WITH(NOLOCK)

Follow

Joseph McGroarty

November 11, 2020 15:37

Is there anyone out there that knows how to have Sisense's queries run WITH(NOLOCK) on MS SQL?

I am running into issues of deadlocks when trying to do anything in Sisense which is impeding my data loading into our Data Warehouse. Whether it be loading an Elasticube or navigating in a dashboard that is a Live Connection type.

0

• 

  Malinda Jepsen November 12, 2020 21:25

  We use views in our MS SQL and add the WITH (NOLOCK) to the tables in the view. I hope that works for you.

  0

  Comment actions Permalink

Please sign in to leave a comment.