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 max_active_sessions (see below).
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.

See Also