sys.dm_pdw_sys_info (Transact-SQL)
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Provides a set of appliance-level counters that reflect overall activity on the appliance.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
total_sessions |
int | Number of sessions currently in the system. | 0 to maximum concurrent sessions |
idle_sessions |
int | Number of sessions currently idle. | |
active_requests |
int | Number of active requests currently running. | |
queued_requests |
int | Number of currently queued requests. | |
active_loads |
int | Number of loads currently running in the system. | |
queued_loads |
int | Number of queued loads waiting for execution. | |
active_backups |
int | Number of backups currently running. | |
active_restores |
int | Number of backup restores currently running. |
Examples
No filters are needed for this dynamic management view:
SELECT * FROM sys.dm_pdw_sys_info;