Kush - which version of Tableau Server are your running?
Hey John, We are running latest 9.1 64bit for windows.
Data Engine is active only when extracts are involved so for live connections, it just sits idle. In your particular use case, adding more Data Engine processes wouldn't improve performance, UNLESS you are using live connection to extract.
If you want, you can send me configuration info on your current Tableau set up, I can eyeball it and see if I can spot anything obvious for improvement. Email me firstname.lastname@example.org screenshot of your server processes and the specs of each machine
Thank you John.
I will certainly email you soon.