If Foglight can see the traffic to database IP, can I capture the SQL call? SQL do not have http header, but set session identifier as IP, I suppose can capture sql raw message--text
You could monitor your DB connections at tcp layer but you could not capture sql calls.
FxM is primarily used to monitor HTTP/https. For your db connection that is not through http, you could only get some tcp related metrics by monitoring the tcp port, however it can not capture sql raw messages.