I recommend the following articles to get started on Tableau Server best practices:
Having Tableau Server share a machine with any other database, webserver, or proxy software is not recommended. Tableau Software is intended to have it's own dedicated machine and resources.
MS SQL Server for example, will take as much RAM as it possibly can at all times, regardless of the database usage. There is no good way to optimize a Server to run both MS SQL Server and Tableau Server since both are expecting to have all resources available, which is not possible.
Thank's for the information and for your time Paul.
1 of 1 people found this helpful
Let me add that one should put Tableau Server in anti-virus software's exclusion list. I have seem it wreak havoc on too many instances. Improving performance by using antivirus exclusions | Tableau Software
Also, if you are using VM's, make sure you allocate 100% CPU and RAM to Tableau Server. No pooling or sharing please. Think hosting a database on VM's.
Thanks for your time John.