1 of 1 people found this helpful
Hi Sarah -
Unless you're planning trying to use extracts to host that 2-5 TB of data, the amount of RAM you put on Tableau Server is really neither here nor there. 32-64 GB of RAM should generally be more than enough.
Why? Because it's your database that will be doing all the heavy lifting when it comes to responding to queries that Tableau sends its way. All Tableau will be doing is taking the "answer" to the question (which is exponentially smaller than the full database) and displaying it to you in an interesting way.
If you will be making heavy use of extracts on the server, then more RAM is better because we can use it during the sorting and compressing phases of extract creation & refresh. Unlike other "data discovery" products, Tableau doesn't need enough RAM to load the entire dataset that you want to analyze into. That is one of the major advantages that Tableau has over our competition. But, if you give us more RAM, we can make good use of it
Hope this helps a little?