The default settings are suitable for most situations but it is possible to manually configure them using the TSM command line interface. The query cache consists of the logical query cache, the metadata cache, and the native query cache. The size of the query cache is automatically set based on the amount of available system memory, as long as you have not set it manually. Tableau Server uses a query cache to store query results. Use the tsm data-access caching list command to confirm the caching frequency is set to low (this is the default). Your refresh tasks should be scheduled for off-peak hours that don't overlap with your backup window.Ĭaching helps Tableau Server respond to client requests quickly,Įspecially for views that connect to live databases. View to see your refresh and backup task schedules. Use the Background Tasks for Extracts administrative Off-peak hours: Backup tasks tend to stall other background tasks until the backup is completed. If you are running Tableau Server in a virtual environment, use your VM host's best practices for vCPU allocation in relation to the number of physical CPU cores on the VM host. The Tableau Server recommended hardware and software On one computer or several, the general rule is that more CPU coresĪnd more RAM will give you better performance. Memory: Regardless of whether you’re running Tableau Server
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |