I do not have a precise method of identifying the connections from Tableau Server to the SQL server machine. But I might have some potential solutions or workarounds depending on what is the desired result of gathering this information. Increased view load times? Decreased strain on the SQL Server? Decreasing refresh times?
Please answer some of the above and I would be happy to provide the information I have.
Hope this helps!