1 Reply Latest reply on Jul 7, 2016 8:51 AM by lindy.eberhart.0

    open sessions with sql server all the time

    Denise Anderson

      Tableau seems to keep five sessions open at all times on our sql server. All of the workbooks are refreshed via a scheduled task early in the morning. Why does it not kill the connections after the task is complete? They stay open constantly and show as sleeping.

        • 1. Re: open sessions with sql server all the time

          Hi Denise,

           

          Here is the info I found from a support case on the same behavior internally: Tableau creates a pool of connections to data sources and keeps them open for future use.

           

          In other words, it sounds like this is by design. I suspect this is to make things slightly faster in Tableau by being able to quickly re-use the connection instead of establishing it from scratch. I'm happy if a developer or someone else in the know wants to chime in.

           

          It is possible to configure your SQL Server to kill old or stale connections if you want to do that. This shouldn't have any negative effects on Tableau Server, as we will simply re-connect if the existing session is gone. Here is a forum post from another customer who did exactly that:Published SQL Server Connection - Always open???

           

          Hope this helps!