sys.dm_pdw_exec_connections (Transact-SQL)
Applies to: Azure Synapse Analytics Analytics Platform System (PDW)
Returns information about the connections established to this instance of Azure Synapse Analytics and the details of each connection.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics. For serverless SQL pool use sys.dm_exec_connections (Transact-SQL).
Column name | Data type | Description |
---|---|---|
session_id | int | Identifies the session associated with this connection. Use SESSION_ID() to return the session_id of the current connection. |
connect_time | datetime | Timestamp when connection was established. Is not nullable. |
encrypt_option | nvarchar(40) | Indicates TRUE (connection is encrypted) or FALSE (connection is not encrypted). |
auth_scheme | nvarchar(40) | Specifies SQL Server/Windows Authentication scheme used with this connection. Is not nullable. |
client_id | varchar(48) | IP address of the client connecting to this server. Is nullable. |
sql_spid | int | The server process ID of the connection. Use @@SPID to return the sql_spid of the current connection. For most purposes, use the session_id instead. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Relationship Cardinalities
From | To | Relationship |
---|---|---|
dm_pdw_exec_sessions.session_id | dm_pdw_exec_connections.session_id | One-to-one |
dm_pdw_exec_requests.connection_id | dm_pdw_exec_connections.connection_id | Many to one |
Examples: Azure Synapse Analytics and Analytics Platform System (PDW)
Typical query to gather information about a queries own connection.
SELECT
c.session_id, c.encrypt_option,
c.auth_scheme, s.client_id, s.login_name,
s.status, s.query_count
FROM sys.dm_pdw_exec_connections AS c
JOIN sys.dm_pdw_exec_sessions AS s
ON c.session_id = s.session_id
WHERE c.session_id = SESSION_ID();
See Also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za