MS SQL (TDS)

Due to the fact that MS SQL Studio may create multiple connections for sending internal queries, the sessions, connected via the TDS layer protocol using MS SQL Studio are getting aggregated by Fudo Enterprise.


Fudo Enterprise follows an algorithm that verifies if there is an already connected session on a current node. If the algorithm identifies that the main connection objects (listener, account, server address (server), user, and safe) of the new session are correlating with already existing session, both sessions are aggregated into one.

If the main connection objects of the new session are not correlating with any of already existing sessions, a new session is created.


This makes multiple queries to be grouped within one session. Every query has a unique tag that allows filtering important connections with users’ queries in the Fudo Enterprise player.

../../_images/5-1-mssql-std-connect.png

Supported connection modes:

Supported client applications:

  • SQL Server Management Studio,
  • sqsh.

Notes:

  • Session joining is not supported.