| title | sys.dm_pdw_sys_info (Transact-SQL) | |
|---|---|---|
| description | sys.dm_pdw_sys_info (Transact-SQL) | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.date | 04/15/2024 | |
| ms.service | sql | |
| ms.subservice | data-warehouse | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDE applies-to-version/asa-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. |
No filters are needed for this dynamic management view:
SELECT * FROM sys.dm_pdw_sys_info;