1 of 1 people found this helpful
Below post is from a Tableau employee
Yes there is a tool called Logshark. ...Find more --->Introducing Logshark: Analyze your Tableau Server log files with Tableau | Tableau Software
Full post ---->Why is my VizQLServer memory consumption so high?
Hey Adrian --
VizQLs *do* consume lots of RAM, and the behavior is completely normal. there is no appreciable difference between the way they work in 9.1 and 9.3 so I'm not sure why you're seeing something different.
When you watch the memory consumption on one (or more) machines over time, you'll typically see more and more RAM being used, and then it levels off. Here's a time compressed version of this behavior as a load test with 60 concurrent users execute constant load against Tableau:
See how available RAM goes down sharply between seconds 0 and 500 and then stays about the same? This is normal, but you're seeing it over the course of an hour vs. a couple of days.
You may ALSO see available RAM go "way back up" if Tableau Server chooses to recycle a vizqlserver process. The Server Resource Manager will do that from time to time. This behavior could explain why earlier on in the thread Toby saw one of his VizQLs using lots of RAM, and another "not so much". The process using less RAM was probably "newer" than the other, having recently been recycled.
Now that Logshark is available to the public, one could use the SRM report which it generates to actually see this happening. It's kind of cool!
Please mark the answer as CORRECT & HELPFUL if it really helps you so that it can help others as well