KNOWLEDGE BASE

Performance Degraded for Some Published MS SQL Workbooks with Federated Queries


Published: 27 Mar 2019
Last Modified Date: 22 May 2019

Issue

After upgrading to a Tableau Server Hyper version, some MS SQL workbooks that use federated queries may take a significantly longer time to render and use up resources. 

Environment

  • Tableau Server 10.5, 2018.1, 2018.2, 2018.3
  • MS SQL

Cause

Some federated queries may cause a locking issue in the data engine from Hyper streams. This issue (ID: 827481) has been resolved in a recent version of Tableau Server.  
Did this article resolve the issue?