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;