Número máximo de conexiones externas simultáneas y N.º máximo de sesiones simultáneas

Question

Hola, necesito su ayuda comunidad, Estoy confundido con la diferencia entre sesiones y conexiones en Microsoft Azure Database, debido a que en la pagina de microsoft se muestra de esta forma

les pido su ayuda para poder entender la diferencia, y si podrian compartirme un script para ver las sesiones asociadas a una conexion Translation: Hi, I need your help community, I am confused with the difference between sessions and connections in Microsoft Azure Database, because in the microsoft page it is shown this way (see image). I ask for your help to understand the difference, and if you could share a script to see the sessions associated with a connection.

Answer 1

Connection represents connection to the Azure SQL Database over a network. A session represents a user process within the Azure SQL Database. A connection may be associated to more then one session. The following query shows all connections and related sessions:

SELECT c.session_id, s.status, c.connection_id
FROM sys.dm_exec_connections AS c
JOIN sys.dm_exec_sessions AS s ON c.session_id = s.session_id
WHERE c.session_id <> @@SPID