| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_pdw_sys_info (Transact-SQL) |
sys.dm_pdw_sys_info (Transact-SQL) |
WilliamDAssafMSFT |
wiassaf |
04/15/2024 |
sql |
data-warehouse |
reference |
|
>=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;