Kunal, did this help?
Knowing the server OS would be very helpful, what is it?
With Windows 2008 R2 you can use the built-in defragmenter with its scheduler.
Yes..it certainly points towards right direction . we are going to
implement windows script and schedule it daily to defrag
Since Tableau server is only on Windows currently what does Tableau say about using Defrag to optimize the disk?
Should it be been run only off-hours? at night? on the less busy weekend? Weekly, Monthly?
I stumbled upon this thread because I want to tune our server more.
Kunal what is your reason?
And did the defrags help?
Jeffrey Lutomski wrote:
Should it be been run only off-hours? at night? on the less busy weekend? Weekly, Monthly?...
It depends on how quickly it becomes fragmented at whatever percentage you deem unacceptable. Just like extracts the best time to do it would be during off-peak hours. If you're not sure do it once a week. I can't see defragging as negatively affecting performance.
But has anyone seen defragging increase performance of Tableau server during the day?
A daily defrag is complete overkill in my opinion
I don't think anyone has tried to actually measure the difference "before and after", but I'd expect it to be pretty small except for the most fragmented drives out there. In that case, a defrag "now and then" would neatly solve this.
In terms of where to put your effort, you'll generally get a much higher pay-off by focusing on the workbooks themselves (are they designed well) vs. turning the server. You might be able to move perf a little bit one way or the other with server-focused tuning...but assuming there isn't something just "dead wrong" on the box, its the vizzes themselves that make users say "Tableau is fast!" or "Tableau is slow!".
In other words, tuning can be fun and educational, but it (generally) isn't going to make a big difference on way or the other.