4 Replies Latest reply on Dec 13, 2016 6:49 PM by Sujay Paranjpe

    Tableau takes Long time to execute Query from SQL Server

    barathkumar vijayakumar

      Hi,

       

      I am using Tableau 9.3 Desktop version. I am pulling data from Microsoft SQL Server to Tableau Desktop and I built the reports. the data size is huge (probably 15 GB) now the problem is that the tableau desktop performance is very poor. it takes more time to execute each query. I tried to create the tde Extract but it took more than 5 hrs but still the extract was not created. so that option is ruled out I guess.

       

      my Suggestions:

       

      1.instead of pulling the data from Microsoft SQL Server if I pull the data from Tableau server and if build those reports then the performance will improve ?

      2.Doing Indexing in SQL server will work for this ?

       

      can someone please help me on this ?

       

      Thanks,

      Bharath